VB Forum / Database Access / March 2006

Do any of the included controls with VB 6 Enterprise offer a grid
which would allow a dropdown box for the valid data entries for a
given column?
It seems like you could do it in VB but I can't remember how.

I have need to copy all the tables from one database to another - both
are different formats
dbA is jet (3.51), dbB is dBase V
I have created two databases objects within the workspace() and want

Hallo, I've upgraded a front-end application based on an Access database
from VB.NET to VB Express.
All works fine but I've noticed that sql queries containing the 'LIKE'
statement now run a lot slower than before (i.e. when I fill the dataset

I have a Data Environment module attached to my VB application which
has a
SQL command object in it like so:
Name: cmdCustomer

Curious problem, I have a VB6 program which uses ADO to connect to an
access table. When run under the IDE or compiled to pseudo-code,
everything works fine. However, when compiled to native code, the
recordset object get set to 'nothing' even though it was successfully

I am openning connection from text file using
Driver={Microsoft Text Driver (*.txt;
*.csv)};DBQ=E:\CSmp\Database;DefaultDir=E:\CSmp\Download;Uid=Admin;Pwd=;
and inserting into one temp table using query

   I was hoping someone has experienced this before, I'm having trouble
googling this.  I'm working with a poorly writtend database that has some
fields named as such: MTIC_PROD_VEND[ 1]
I do not have the option to rename this field but I do need to retreive data

I am new in programming. I am using visual studio.Net. I try to open
file and add record to it. but each time I over write the first record.
Can somebody Email me how to open file in ADO so i can have some
records added to it. I will appreciate any help. Any VB code for index

Can anyone point me in the direction of a visual basic .net newsgroup - all
this is new to me?
Thanks

This returns records where the criteria is met in either of the values
in the in(..).
I need a SQL that only returns the records that matches ALL the values
in the In(..)

I am using several DTpickers in an app that writes to a Jet DB. My problem
is that when I allow users the checkbox option in the DTPicker to write a
null value to the DB, how do I get the DTPicker to show something like "No
date selected" when the record is brought back up on the ...

Hi...
I'm currently working Vb6 Datareport.
This work but, datareport listing old data.
I'm using "deconnection.rsdbxxx.requery", but "Error : Object closed....."

I am getting data from 2 tables (folders and subfolders, both are huge).
First I joined them in one SQL statement, then loop through one
recordset.
It was slow.

I have two tables.  One table (Table 1) has a column containing comma
delaminated email addresses.  The other table (Table 2) has a column
with just one email address in it.  I need to perform a query that
joins the comma delaminated table (Table 1) to Table 2, when the single

Hi... i am currently working on switching our database from Access to
SQL and while most of the required changes have been taken care of, the
problem which still persisting is:
We have a recordset, the query for which is somewhat like this...