Make-Table Macro for Dummies (No Code)

[ALewis06]

I need to record a macro that runs a make-table query, that answers "Yes" to the prompts, and that closes so that the next query in sequence can run. From a few links I've Google'd looks like you have to write some code for that but I know nothing about writing VBA code. Workaround?

 

[pbaldy]

Are you looking for SetWarnings? If so, don't forget to turn them back on at the end.

 

[ALewis06]

I suppose that is what I am looking for, but I don't know where to find them or how to make them part of my macro. I am using the easiest method for me to build this--the Access 2007 Macro builder. Back to Google I go to see how to use SetWarnings.

And what do you mean to be sure to turn them off after use? I want this macro to remain part of the database so that when users engage the front end, the macro can just be what's behind a "Refresh" button on the switchboard menu.

 

[pbaldy]

It should be in the actions dropdown. You may have to click on Show All Actions in the ribbon.

 

[ALewis06]

Can you expound on what you meant by removing it afterwards?

 

[pbaldy]

Oh, and basically

turn warnings off
run query or queries
turn warnings back on

 

[ALewis06]

Ok. I'll give it a go

 

[pbaldy]

Post back if you get stuck. You want to turn the warnings back on because it will carry over to everything else, like closing a form after working on the design. You won't get the "do you want to save your changes" prompt if you don't turn the warnings back on.