Turn_off confirm message"Table will be deleted" inside a Macro

D

Don

I am running a Macro that opens a MkTb Query. This Macro is Sub to a
RunMacro command that repeats a calculated number of times. I can not get
the Macro to run without the confirm message "Table ... will be deleted"
appearing and having to click yes on the confirm message. This Macro will
cycle as many as 200+ times. I have tried to turn off tools -- options --
confirm -- document deletions but this does not work. I am using Access
2002. Thanks for any suggestions
 
D

Douglas J. Steele

Try setting SetWarnings to False before the deletion. Don't forget to set it
back to True when you're done.
 
D

Don

Douglas solved my problem. Thanks
--
Don


Douglas J. Steele said:
Try setting SetWarnings to False before the deletion. Don't forget to set it
back to True when you're done.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top