Removing the Confirmation dialogs on maketable queries

  • Thread starter Thread starter Michael Kellogg
  • Start date Start date
M

Michael Kellogg

I update a couple of tables each morning with refreshed data, and I use a
MakeTable query to accomplish this. I have macro-ized this process, but I
don't know how to go about removing the confirmation dialogs that come up
during the update ("You are about to paste xxxx records...", etc.). How
can I do this?

Doing this with a short macro seemed the simplest approach; is this still
kosher, or am I better off taking a little extra time to do it in VBA?

Thanks for any help.
 
Make the first action in your macro a SetWarnings False
Then the queries.
Make the last action in your macro a SetWarnings True
 
Cheryl Fischer said:
Make the first action in your macro a SetWarnings False
Then the queries.
Make the last action in your macro a SetWarnings True
Click to expand...

That worked great! Thanks!
 
Back
Top