tdjfdjdj tdjfdjdj - 5 months ago 40
SQL Question

MS Access - execute a saved query by name in VBA

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.

CurrentDb.Execute queryname


You can do it the following way:

DoCmd.OpenQuery "yourQueryName", acViewNormal, acEdit