Hide Query Prompts

  • Thread starter Thread starter SteveH
  • Start date Start date
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.
 
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
 
Where do I find the SetWarnings command. It's not on the list of macro
functions.

Thanks,
 
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
 
Back
Top