Once you start doing some VBA programming in your database you will at some point or another want to run/execute queries through VBA. However, you may not want your user’s to receive the action query confirmation prompts, such as:
MS Access Action Query Confirmation Prompt Message
Nothing could be easier. To disable all confirmation prompts simply use the following line of code
DoCmd.SetWarnings False 'Turn off warningsOf course do not forget to turn them back on after running your code so that legitimate messages are displayed.
DoCmd.SetWarnings True 'Turn warnings back on
Tuesday, October 19th, 2010, 8:00 am | 
MS Access VBA Programming | 
RSS feed
Pinging is disabled. But you can skip to the end and leave a 
response.