tdjfdjdj tdjfdjdj - 1 year ago 115
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

Answer Source

You can do it the following way:

DoCmd.OpenQuery "yourQueryName", acViewNormal, acEdit


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download