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
Turn off warning message 4
Documents from shared model are created with design mode on 1
action query prompts 2
Close all without saving and exit without prompts 8
How do I turn off annotating with ink in Excel 2016 2
turn off password 1
Turn off 'Undo' buffer? Don't want messages. 3

Top