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
 

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
Append Query Issue 0
Opening query as read-only 2
Message box when query finished 1
Turn off update query prompts 5
Update query should not fire if prompt is null 1
update undo query 1
Access 2010 append query to SQL is very slow 0

Back
Top