Suppressing Messages during queries

  • Thread starter Thread starter Kevin G
  • Start date Start date
K

Kevin G

Is there a way to suppress all messages that are displayed
while I'm running a macro that performs these tasks in
order 1) a make table query 2) an append query 3) exports
to an excel spreadsheet. What I want to get rid of, if
possible, is all of the "You're about to make a
table", "The table exists do you want to write over
it", "You're about to append", "This workbook exists".

Any help is appreciated.

Thanks,

Kevin G
 
Go into your macro. Add a new line at the beginning.
Select Setwarnings. And set the value to NO. That should
eliminate the messages.
 
I believe what you want is the DoCmd.SetWarnings {True | False}

This globally affects the applications so make sure you set the warnings
back on after you are done in the procedure/function, after an error (in
your error handler) or when you end the application.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top