OpenQuery dynamic alternative?

[Ron]

Hi,

Is it possible to define a select query within VBA and then open it?

I would like to be able to define a select query dynamically from VBA
according to data that is held in another table.

Regards,
Ron.

 

[Ofer]

Create an empty query, name it DynamicQuery, and try this code to assign new
SQL to this query, and then open the Query

Dim db As Dao.Database ,myqs As Dao.QueryDef

Set db = CurrentDb
Set myqs = db.QueryDefs("DynamicQuery")
myqs.sql = "SELECT * From TableName"
Docmd.OpenQuery "QueryName"

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CreateQueries2.mdb" which illustrates how to do this. More
advanced samples include: "CreateQueries3.mdb", "CreateQueries4.mdb", and
"CreateQueries5.mdb"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Ron]

Thanks guys!