Create Query in Visual Basic

G

GrandMaMa

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
 
M

Marshall Barton

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?
 
Top