Run query from module

[lintz]

I've created and save a query within Access and want to run it from within one of my modules. I have searched but can't find how to call it.

Can anyone help?

[salvelinus]

DoCmd.OpenQuery "your_queryname_here"

[dannymking]

Salvelinus' method is one of many.

If you know the SQL then you can do just.. (This is the more efficient method)


CurrentDb.Execute "SQL String"


or you can pull the SQL from the query and then run it..


CurrentDb.Execute CurrentDb.QueryDefs("Query Name").SQL


As a note always use CurrentDb.Execute in favour of DoCmd.RunSQL, especially when performing action query's as this removes the need to suppress confirmation messages generated by the DoCmd.RunSQL method, and it is more efficient.