Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

To use DAO AS In VB

Status
Not open for further replies.

dinu79

Programmer
Mar 24, 2002
17
0
0
IN
Hi
I want to ask a very simple question
Is it possible to make DAO connectivity in Visual basic editor an in Visual basic
Actually i want to select some values from the table forms some specific value. Is any other way possible
Thanx
 
Hi,
If you are using Access 97, just do like this:

dim rs as recordset
set rs = currentdb.openrecordset("Select * from tab where .....")
rs will contain your data, and acts just like it would in VB.

You can also use ADO. Just open a module and go to project|references, just like you do in VB.

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top