M
MS751
How do I create a macro that will run a make table query?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
MS751,
First make the Make-Table query.
Then, in the macro designer, make a new macro using the OpenQuery
action, and nominate the name of your query. Save and name the macro.
Assiign the macro on the applicable event property where you want the
Make-Table to be triggered. Once you have it working correctly, you
might want to add a SetWarnings/No action to the macro, before the
OpenQuery, to suppress the display of the confirmation prompts.
First make the Make-Table query.
Then, in the macro designer, make a new macro using the OpenQuery
action, and nominate the name of your query. Save and name the macro.
Assiign the macro on the applicable event property where you want the
Make-Table to be triggered. Once you have it working correctly, you
might want to add a SetWarnings/No action to the macro, before the
OpenQuery, to suppress the display of the confirmation prompts.
M
MS751
Thanks, How do I assign the macro on the applicable event property where I
want the Make-Table to be triggered?
want the Make-Table to be triggered?
S
Steve Schapel
MS751,
You enter the name of the macro in the event property.
When do you want it to hapopen?
You enter the name of the macro in the event property.
When do you want it to hapopen?