Create Query in Visual Basic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Access Help has stopped working if you are wondering why I need this from
the Users Group.

I need an example of how to create a Query in Visual Basic. (Create Query)

Thank You in Advance.

Granny
 
GrandMaMa said:
My Access Help has stopped working if you are wondering why I need this from
the Users Group.

I need an example of how to create a Query in Visual Basic. (Create Query)
Click to expand...


Dim db As DAO.Database
Dim qdf As DAO.QueryDef

Set db = CurrentDb()
Set qdf = db.CreateQueryDef("queryname")
qdf.SQL = "SELECT . . . "

But there many variations on that. Have you tried repairing
or reinstalling Access?
 

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

Microsoft Office Access failed to create the Visual Basic module 1
Dialog Box - Visual Basic relation 11
Visual basic error in access 2000 1
Access Query problem 1
programing in visual basic 1
Programing in Visual Basic 1
Using Visual Basic Net as front end - Access as back end 18
displaying Query results to subform 3

Back
Top