Run A query from a Macro

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
 
V

Van T. Dinh

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)
 
Top