querying database through vb6

P

Perry

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
 
B

blondie

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
 
C

Chris

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Pipe character in query in VB6 app 11
Multi-select list box for multi-column query 2
Page numbering with Merged Document and IF statements 1
Sorting and filtering text 0
My Visio2019 Keep Crashed when open the program 0
The error "Not a Dbase database". 0
Access Query to import from Sharepoint 0

Top