VB Forum / Database Access / October 2004

The code above is relevant but it gives problem when run. I stored
Daily_Rubber_Crop table in MS Access database and set the data type of
date/time but when i retrieve the data it pop up a message "Data type
mismatch in criteria expression". Do anyone know why this probem occur and

Hi all... here's something that's been throwing me for a loop.
I have a series of foxpro tables on PC1.  It is accessed by PC1 and 3 other
PCs via a shared/mapped drive.  (all this installed by a commercial
application.)

Anyone out there happen to know how I can access a visual foxpro database
from visual basic?
Also, what method to use that would be best.  The database is on a network
drive used by 4 other people via a commercial application.  I only need read

I have built a recordset like this
rs.Open "SHAPE {select aaa,bbb,ccc,ddd, from tab1 Order by aaa} AS ParentCMD
APPEND ({select eee, fff from tab2 Order by eee} AS ChildCMD RELATE aaa TO
fff ) AS ChildCMD", cn, adOpenStatic, adLockOptimistic

hello my self avi.
i want to add a bulk data in combo box and list box.
but as per my knowledge i can enter only one item at a time.
here i am showing my code in which cmbhaste is combo box in which i am

Any and all,
Anyone know how to create a big int in VB60 to fill an SQL Server big
int field? I am looking for a Big Integer type to hold a number to
pass to a big int field, but I don't know how to form a Big Int

Group,
I'm a newsbye on vb. I've been studying access a long time, and it's simple
to access the database, just make a connection, then set it with
data!variable.

how to access a blank date in vb select

I have a SQL text field storing free form notes.  I am
trying to access them through an ADODB Recordset connection
but the text field always returns blank (but not empty) it
knows data exists but can not output it within the

I have build a recordset in ADODB selecting multiple fields from
multiple tables. This is working fine.
But now I tried to add a field to this recordset and I get an
error message saying Connection Failed.

Anyone out there happen to know how I can access a visual foxpro database
from visual basic?
Also, what method to use that would be best.  The database is on a network
drive used by 4 other people via a commercial application.  I only need read

I have a VB7 aspx file I am creating that requires multiple queries each
dependant on the previous queries results. If I run these queries in foxpro,
I just run a query then create a cursor with the results of that cursor, then
run another query based on that cursor etc. My ...

My application has a form containing a adodc component and a command button
associated with the following codes:
Private Sub cmdSearch_Click()
  Set cn = New ADODB.Connection

Hi *.*
I want to connect my windows application to a database located on internet
with ADO (SQL Server Provider), the main question is:
Is it safe?

I'm rather new in VB in combination with databases and I have the following
problem.
I must reed a textfile and import this in a MS Access table.
The textfile contains lines in which the data for the differents fields is