Hide Query Prompts

[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.

 

[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

 

[SteveH]

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

Thanks,

 

[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