By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,402 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

How to get rid of the warning message?

P: 51
Hi,
How can I get rid of the warning message such as "the exiting table "table name" will be deleted before you run the query", when I run the macro?
I've made a macro that run several queries and those queries are make table queries. I just want it to run without those message.
Thanks alot!
Elaine
Sep 14 '07 #1
Share this Question
Share on Google+
3 Replies


MindBender77
100+
P: 234
Make the first line in your macro "SetWarnings". The options are Yes or No. The default is No, meaning, "No Warnings" will be displayed when any of the queries are executed.
Sep 14 '07 #2

Scott Price
Expert 100+
P: 1,384
DO NOT forget to turn the warnings back on after your macro runs! On the last line of the macro reset the warnings to Yes again.

Regards,
Scott
Sep 14 '07 #3

P: 51
You guys are great. Thank you very much!. This website is so helpful.
Have a nice weekend!

Elaine
Sep 14 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.