Turn off prompts that alert

[Guest]

Hi,

I have a Macro in the "Macro" tab in acess that runs 3 queries. When I run
the macro it asks "Do you want to delete Table XYZ" and "You are about to add
XYZ rows to table".

How do I turn off these prompts, because if they were off the macro would
run more smoothly.

Thanks for your help!

 

[Guest]

docmd.setwarnings = false

docmd.setwarnings = true

 

[Arvin Meyer [MVP]]

Although I wouldn't advise it, you can turn off all action query prompts in:

Tools >>> Options >>> Edit/Find >>> Confirm

There is no way to turn off individual prompts in queries except when
running in code. Then scubadiver's post will show you how.