VB Forum / Database Access / February 2005

VB6 code snippet:
with cmd
  .cmdtext = "exec buildwordlist 11"
  .commandtype = adcmdtext

Is it possible to programmatically lock a single record in a VB application
using DAO 3.6?  I would like to lock users' records when they log on to the
app.  Later I can check if a user's record is locked to see if they are
logged in or not.  (I could do this before with DBF ...

I have written a database management system but when I try to install it on
to a PC I get an error occur in the set up.
The error is : C:/WINNIT/sys32/msado25.tlb
                   Error while registering

I am trying to run a SQL statement from a VB application
and am receiving an error message.  However, when I run a
similar statement from Access using a query, I do not get
the message and it executes successfully.  The message

I want to lock users' password records after they log on to a VB6
application.  I want to be able to determine who is logged on to the
database by polling each password record to see if it is locked or not.
(DBF files allowed this sort of  locking and checking to see who was ...

i've finished my 1st form, and now i have to create another form, which
enables me to move through records, and make modifications.
i want to use a simialr sort of form, as my 1st one, but need a couple of
extra buttons to move forward 1 record and move back 1 record. I'm guessing

I have a problem related to a field in a SQL table whcih is an "image"
datatype. The powers that be here claim it is a bmp. I think it is not, or
that it is encrypted in some way. I would like to test my theory by reading
the data in the field and writing it to disk. Then I want ...

Looking for some ideas ? ADO / RDO ?
I need to develope a visual basic application that when a user launches the
application it checks to see if the datase for the user is created if the
user does not have a DATABASE it creates one then creates a table in the

I am trying to get a selection of fields from a DB.
I can select specific records using
sql = "SELECT * FROM cds WHERE Artist = 'bryan'"
rs.open sql,cn

I'm having a problem with handling null values in a vb6(sp6) program.
For some reason a if.else.endif statement seems to work fine with
detecting a null value and assigning a default if necessary(1).  I
would like to use the iif statement instead(2), but it always throws

I am trying to run an SQL query on a database through VB6 which is supposed
to add data to a table called tblNames.  There are 4 text fields on the form
where data is added.
here's the code.

I am looking to open excel file with vb recordset.
so my all recordset information goes into Excel file.
Thanks in advance
Raj

Please can you advise on the best way to create reports in VB6, my
application is linked to a MySQL database. I want to create a Purchase
Order Report from a query linking 4 different tables what is the
easiest way to do this.

I am using VB6 and ADOX 2.7.
I need to add a field (column) to a Catalog's Table's Column's collection
with a default value. Is there a way to do this? I don't see it in the
properties collection when it is instantiated nor when it has been appended

Private Sub cmdLookUpGroupInfo_Click()
In the code below, I succesfully was able to bind and polpulate a text box
with my select statement. But I need multiple table rows to be populated so I
cannot use the text box. So I am trying to use the datalistbox or the