Previous Thread

8/17/2006 12:35:40 PM    Record a Macro
How do I create a macro that will run a make table query?



8/18/2006 8:57:08 AM    Re: Record a Macro
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. 
 
-- 
 
Steve Schapel, Microsoft Access MVP 
 
MS751 wrote:

8/18/2006 11:27:08 AM    Re: Record a Macro
MS751, 
 
You enter the name of the macro in the event property. 
 
When do you want it to hapopen? 
 
-- 
 
Steve Schapel, Microsoft Access MVP 
 
MS751 wrote: