Can VBA code change an existed query. The query on the left side of the window that you see and had written.
For example in the query is as:
SELECT *
FROM tb
WHERE fielda = “app”
To
SELECT *
FROM tb
WHERE fielda = “toys”
Competent Performer
Windows 7 64bit 
Access 2010 64bit
Can VBA code change an existed query. The query on the left side of the window that you see and had written.
For example in the query is as:
SELECT *
FROM tb
WHERE fielda = “app”
To
SELECT *
FROM tb
WHERE fielda = “toys”
Who is John Galt?
Windows XP Access 2007
You can change the SQL of a saved query with a DAO QueryDef. That said, in your example I'd just use a criteria pointing to a form control (a parameter query).
Competent Performer
Windows 7 64bit Access 2010 64bit
My query is more complex than that. That is just a simple example. Can you show me an example of how VBA can change an existed physical query ?
Who is John Galt?
Windows XP Access 2007
Transfer Spreadsheet Command Not Seeing Query Object Created with Code
Posting Permissions
Reply With Quote