Dynamically Create Query

  • Thread starter Thread starter ToNo
  • Start date Start date
T

ToNo

How can i dynamically create Query in the Access Database.

Actually, I want to save the query created by me in VB
code in Access .
 
How about a QueryDef? They are created in code and can be temporary or
permanent, depending on whether you provide a name. Check out the
CreateQueryDef method in VBA Help; it's easily found by typing
"createquerydef" (without quotes) in the Answer Wizard.
 
Thank's a lot..


-----Original Message-----
How about a QueryDef? They are created in code and can be temporary or
permanent, depending on whether you provide a name. Check out the
CreateQueryDef method in VBA Help; it's easily found by typing
"createquerydef" (without quotes) in the Answer Wizard.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.
Click to expand...
 
You must log in or register to reply here.

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

Use In() Expression as Query criteria with guts from Function 1
dynamic calculated field in query 3
Make Table Dynamic Table Name using INTO 2
dynamic crosstab query 2
help append query with dynamic fileld to table 0
Parameter Query Won't Run 0
Change name of column queried "on the fly" 2
Multiple fields for same type of values 5

Back
Top