Suppress promt in Update Query

  • Follow


I have a macro set up that runs an update query.  (macro attached to a button)

I am wondering if there is a way to stop the two dialouge boxes that come up 
when the query is run.  I don't want to confuse the users.

Not a big deal if it's not possible.  I will just tell them to click yes/Ok
0
Reply Utf 5/22/2007 8:25:02 PM

On Tue, 22 May 2007 13:25:02 -0700, cprav wrote:

> I have a macro set up that runs an update query.  (macro attached to a button)
> 
> I am wondering if there is a way to stop the two dialouge boxes that come up 
> when the query is run.  I don't want to confuse the users.
> 
> Not a big deal if it's not possible.  I will just tell them to click yes/Ok

If you are Macros, add a macro (SetWarnings = False) just before you
run the query, and another Macro (SetWarnings = True) after you run
the query.
-- 
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
0
Reply fredg 5/22/2007 8:41:06 PM


1 Replies
453 Views

(page loaded in 0.027 seconds)

Similiar Articles:
















7/20/2012 9:50:04 AM


Reply: