VB Forum / Database Access / December 2005

Hi. Have a prob with an access DB. I have a library DB. On the bookCopy
table there is a yes/no field called IsOnLoan. Now, what I am trying to
do is to get the form to either check that the IsOnLoan field for a
particular book = no (ie is on the shelf). Ive tried everything. The

I'm using a datacombo box in an application.
It works fine when someone has made a selction and I use:
    adodcClient.Recordset.Bookmark = dcClient.SelectedItem
       MsgBox "Client Selected: " & dcClient.SelectedItem

I am considering creating a commissions database for a customer using
XP Pro. I have VB6 professional, but I don't know if any database
support comes with XP. What drivers or tools would I need to install
on their machine to create and edit databases? I will be developing

I am frustrated by the ADO vs. RDO data controls in Visual Basic.  It
seems that I cannot ever get the right combination of data control and
data visualization control.  And the help is no help.
Here is what I would like to do:

I am having some strange things happening when updating a record from a
databound combobox. First of all here is my code.
'bind the look up data table to the combobox
cboEPayer.DataSource = Me.DataSetMisc1.TblPayer.DefaultView

using vb6, ado/adox 2.8, .mdb format files.
I have created a table named "Families"
with two fields
   "FamilyId" - adInteger, autoincrement = true, PrimaryKey

Is there any harm in doing a Filter instead of a Find when
searching a recordset?  I can't really think of any but
wanted some opinions from those that know more about this
than me.  I have a recordset of companies.  Some companies

Having looked at previous posts about Zero length string i still carnt quite
work out the syntax to allow them when i create my table
Code:
With NewTable

I am trying to create a windows form that is based on a maser detail layout
(dropdown with a data grid). My problem is that I am using two differnt
databases for either part of the form, and VS does not seem to want to create
the relationship and WHERE statement properly. Has ...

I have a program that needs 3 different recordsets.  Currently, I am
creating the recordsets when a combobox gets focus.  There is
one combo box for each recordset needed.  Would it be better to create
all 3 recordsets when the form loads?  I figure it would be quicker in the

here's a sub to enter a record into a table of a database via vb6, ado2.8
I'm wondering how best to enforce a "rule" regarding legal entries in this
field
here I use an array and check each item

I wish to get a list of all the tables that i have in my access database,
Namly so my user can choose which table that they wish to view in my VB6.0
application.
Many thanks,

This is driving me nute!!
Visual Basic 6.0
Windows 2000
Microsoft DAO 3.51 object library

I'm trying to update lots of records in an Access back-end DB.
(Microsoft.Jet.OLEDB.4.0)
I loop through 500 records in less than 1 second, until I get to the
UpdateBatch command - which takes 25 seconds!!

When i do the following:
Dim sqlGeneric as Recordset
Set sqlGeneric = New Recordset
sqlGeneric.CursorType = adOpenStatic