Run A query from a Macro

  • Thread starter Thread starter stephen
  • Start date Start date
S

stephen

Guys

New to this

Can any one tell me how to run a query from a macro
RunSQL allows only 255 character

Any ideas

Thanks in advance
 
Check Access Help on the OpenQuery Macro action.

You can also use the RunCode Macro action to run a VBA function that uses
the DoCmd.RunSQL to execute your SQL String.

I presumed you are talking about an Action SQL String, not a Select SQL
String.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top