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




.
 
Back
Top