Turn off prompts that alert

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top