Update/Append Queries minus confirmation Dialouge

[news.newsguy.com]

Does anyone know how to silence the confirmation dialogue appear when you
run an update or append query. The first message box asks for confirmation
before you run and update table records. The second shows the number of
records that will be updated. I'm trying to automate an application with
various queries and macros and need to eliminate these message boxes from
the end-user.

Thanks for the help!

 

[Steve Schapel]

News,

In a macro, you just need to put a SetWarnings/No action before the
first OpenQuery action.

 

[news.newsguy.com]

Excellent. Worked like a charm. Thanks for the help!!

 

[Tony Toews [MVP]]

Does anyone know how to silence the confirmation dialogue appear when you
run an update or append query. The first message box asks for confirmation
before you run and update table records. The second shows the number of
records that will be updated. I'm trying to automate an application with
various queries and macros and need to eliminate these message boxes from
the end-user.

Steve gave you the correct answer for a macro but if it's in VBA code
then you should be using currentdb.execute strSQL, dbfailonerror.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/