querying database through vb6

  • Thread starter Thread starter blondie
  • Start date Start date
hi debbie,

What do you mean with querying a database?
Do you want to run a query from VB?
'(Access Lib is referenced VB Project)
Dim ac As New Access.Application
ac.OpenCurrentDatabase ("D:\MyDocs\Access\Mydatabase.MDB")
ac.DoCmd.OpenQuery "select * from ATable"

If this isn't what you mean, kindly elaborate some more.

Krgrds,
Perry
 
hello again

this is the sort of thing im looking for i think, could
you please help. on my form in vb they user can pick an
attribute and type sum txt they wish to search for. when
the click the button i would like access to open relating
data. this is stored on 3 linked tables in microsoft
access.

any ideas

many thanks
 
I would recommend opening the data through ADO and
displaying it in a grid control.

I would recommend reading a VB and database book.


Chris
 
Back
Top