VB Forum / Database Access / March 2006

I am trying to load data in a table (MS Access) into a combo box (VB 6). The
data is a lot to use cboEntry.additem "aaa". Is there any other way to do
this? The table has 250 records and four fields, however, I only wanted one
field in the combo box. Help please.

I have an MSAccess database in which many of the fields
could be handled much more efficiently if I could address
them as arrays, but I have not been able to find a way to
do this.

I'm working with vb6, and having to connect to a Microsoft Access database
that the user picks out. I have this part working great - I'm connected.
However, the table names are different from db to db (such as station1data,
station2data, etc.) I need to find a way to determine ...

Is the above feasible ?
Regards,
Philippe

The following code creates and opens a disconnected recordset.
On some machines I get an error 429 "ActiveX component can't create object"
This has happend on Win ME and on Win XP.
Does anyone know what could be the source of the problem?

Hello to all.
I'm trying to implement a search option for my users to be able to easealy
search specific information in a VB interface program that is "managing" an
Access database.

I'm working with vb6, and having to connect to a Microsoft Access database
that the user picks out. I have this part working great - I'm connected.
However, the table names are different from db to db (such as station1data,
station2data, etc.) I need to find a way to determine ...

If I use SQL for querying an ACCESS database, how can I count the total
number of selected recrods?
I have set "Set res = New ADODB.Recordset" & "Set cnn=New ADODB.Connection".
Is "res.RECORDCOUNT" the one that I am looking for?

I use excel driver to retrieve the data (not allowed to use excel object
libaray), the driver seems cannot get the data from the worksheet that contains
any space(ie. "worksheetname" but not "worksheet name") . Is this can be solved
?

I use excel driver to retrieve the data (not allowed to use excel object
libaray), the driver seems cannot get the data from the worksheet that contains
any space(ie. "worksheetname" but not "worksheet name") . Is this can be solved
?

I am writing a VB project that connected to an Access Database.
An interface is created for users for querying and comboboxes are provided
for them to choose different field(Actually these are the Field Name in the
Access table) as they needed.

I am trying to pass a record from a recordset into a Sub using VB6.0.
I am obviously not doing this right, could someone kive me a hand?
Here is what I have:
 Do Until rst.EOF

I have this query to pull the data out from the system. And whenever I
run this, I get the "Syntax Error (Missing Operator)" Error displayed.
   Set conn = New ADODB.Connection
   FilePath = App.Path & "\Calls.mdb"

Hi iam connecting excel 8.0 with VB 6 using "opendatabase" function.
now i have few fleilds in excel which are BLANK, iam using a statement
If rsAdd.Fields(6) Is Null Then
but i am getting an Error "OBJECT REQUIRED"

I have this query to pull the data out from the system. And whenever I
run this, I get the "Syntax Error (Missing Operator)" Error displayed.
   Set conn = New ADODB.Connection
   FilePath = App.Path & "\Calls.mdb"