Turn off prompts

R

rhughr

Hi,

Whilst executing a macro with many SQL statements, Access keeps
prompting me to approve the actions such as deleting, etc. Is there
anyway to turn this off? I just want to perform the actions without
being pauses or prompts.

Thanks.
 
J

Jeff Boyce

The SetWarnings works inside Macros, the DoCmd. version inside code.

And I agree ... if you forget to turn them back on, Access won't tell you
when bad things are happening.
 
S

Someone

Sorry, yes, you're right - I forgot he mentioned macros.

Thanks for pointing that out.

M

The SetWarnings works inside Macros, the DoCmd. version inside code.

And I agree ... if you forget to turn them back on, Access won't tell you
when bad things are happening.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to turn off the prompts of a make table query? 3
action query prompts 2
Turn off warning message 3
Set Warnings false is misbehaving 2
SQL Select Query Prompting for NonExistent Parameter 8
Outlook deleted without any prompt 3
Auto Fill prompt 1
Am I missing a refence for the Tools=>Confirm for action query? 2

Top