How do I execute a saved query in MS Access 2007 in VBA?
I do not want to copy and paste the SQL into VBA. I rather just execute the name of the query.
This doesn't work ... VBA can't find the query.
You can do it the following way:
DoCmd.OpenQuery "yourQueryName", acViewNormal, acEdit