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

Avoiding 'Delete Table' Warning in Make-Table Query

P: 46
Hello,

Does anyone know how to avoid the 'delete table' warning that comes with a make-table query?

As an example, I am referring to this message box:



Thank you!
Feb 13 '08 #1
Share this Question
Share on Google+
3 Replies


Scott Price
Expert 100+
P: 1,384
In VBA code you can (assuming you are calling the make-table query from a command button) place this code before the code that calls the query:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.SetWarnings False
  2.  
Don't forget to turn them back on before leaving the subroutine by using this code:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.SetWarnings True
Regards,
Scott
Feb 13 '08 #2

P: 46
Works perfectly - many thanks.
Feb 13 '08 #3

Scott Price
Expert 100+
P: 1,384
You're welcome! Glad it works for you.

Regards,
Scott
Feb 14 '08 #4

Post your reply

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