Hide Query Prompts

S

SteveH

I have a command button the runs several update and delete queries using a
macro. Is there any way to silence the prompts that say you are updating x
records or you are about to delete x records? Any help is appreciated.
 
J

Jeff Boyce

Steve

The SetWarnings command can disable the display of those warnings.

****WARNING**** ****WARNING**** ****WARNING****
If you 'forget' to turn the SetWarnings back on, you will not know when bad
things are happening...
****WARNING**** ****WARNING**** ****WARNING****

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

SteveH

Where do I find the SetWarnings command. It's not on the list of macro
functions.

Thanks,
 
J

John Spencer

It is on my versions (97 to 2003). What version of Access are you using?

If you are using Access 2007, you will have to click the Show ALL Actions
button on the ribbon. SetWarnings is considered one of the "dangerous"
options and is not displayed when you are viewing only the safe options.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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
Unwanted Prompts 4
Turn off warning message 3
Turn off update query prompts 5
Automating Macro Responses 5
update query using like criteria 3
No Records Deleted Message 1
Another Query Modification Question 6

Top