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

set delete query warnings off

P: 20
I have created a delete query and it works fine. When the query is run a message box appears asking if you wanna delete the records etc....?

Is there a way to stop this message box from appearing?
Sep 17 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I have created a delete query and it works fine. When the query is run a message box appears asking if you wanna delete the records etc....?

Is there a way to stop this message box from appearing?
DoCmd.SetWarnings False

Will turn off the warnings. However, be sure you set them back on again afterwards or all warnings will be turned off. To set them back on ...

DoCmd.SetWarnings True
Sep 17 '07 #2

Post your reply

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