Try turning the warnings off (using SetWarnings) before you run the queries.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.
I want to eventually automate this process by calling a Vbscript in a
daily scheduler
( So I don't want any messages to stop the macro from processing )
I have office 2007.
I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.
I don't know where I can disable these messages if it's already unchecked.
Please Help