Record a Macro

[Guest]

How do I create a macro that will run a make table query?

 

[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.

 

[Guest]

Thanks, How do I assign the macro on the applicable event property where I
want the Make-Table to be triggered?

 

[Steve Schapel]

MS751,

You enter the name of the macro in the event property.

When do you want it to hapopen?