VB Forum / Database Access / June 2006

Hi I would like to know how to import data from different tables within
a .mdb file into another one knowing the structure of the first and
really extracting just the usefull data.
What are the SQL commands, syntax, structure for scripts

I'm an experienced Access/VBA programmer, trying to become competent
using VB.net.
Using base vb.net it seems to me to be an AWFUL amount of work to
create data-entry forms similar to what one could create in Access in

I have a dataset with 12 records, the thing is I need to bind this data
to 2 different datalit controls so that the first contains records 1 - 6
and the second contains records 7 - 12. How can this be done? Can the
data in the dataset be split into 2 tables in the dataset? or how?

Visual Basic 6.0
How do I find out about ALL ODBC connections on the Client (no actual live
connections)?
I basically want to see what the ODBC Administrator sees but via Visual

I am attempting to make an equivalent of the DLookup function found in
Access, but I'm doing so in VB 2005 (which pulls a specific value from a
given database table with the criteria given).
Here is the code...

I have an app that is written in VB6 and connects to a SQL 2000
database. I created a table for users that the app uses in order to
authenticate the users at login of the app. I would prefer to connect
the login to the actual users section of the database. Is this possible

I have an application that is getting this error (Number 2147217887). I am
trying to update the database and I say
rst!SFNAME = Trim$(txtSfname.Text)
rst.Update

Okay, I am stumped - and hopefully someone can help.
I have a database which generates reports, and assigns a name, and a
wildcard value which is the date.
Then I have a procedure which if the same report is run, comapres the

I have defined a query using OpenSchema which it seems is truncating
the schema name from before the underscore. My query is thus and
moConnection is using a newly declared ADODB.Connection.
Dim oRS = ADODB.Recordset

I am trying to get to terms with the use of updating through a data adaptor
in VS 2005.
The application allows the user to create forms and add fields and tables to
the database and so the code has to be generic.

I've got a very strange problem.  Basically, I have an access table of
data, which users can input values into via a form.  Some parts of this
form have vb code to enable the user to input a shortcut for a word,
such as "e" for "English" and then the VB code will convert it into the

I am writting a program that analyze the database,
(In Oracle 9.i - TOAD - query runs properly,
but when I use ADODB.recordSet I cannot run the query).
I use VB. 6.0

I have a problem that is not making sense. I wrote a module in MS
ACCESS 2003 to extract data from a Query and send a summary email. I am
not the best VB programmer so what I did was wrote this code for every
table I had to pull from. I receive an error at the .Open method that

I'd like to  know how can I know (from a VB application) how many user are
conected to a MSDE Database?
Best regards,

hello every body.i'm a begginner in asp so i have some trouble to
update my table.
actually i'm using sql200 for my database. there no errors but when i
check in my table the