Crystal has already answered your question, but if you want more detail see:
Action queries: suppressing dialogs, while knowing results
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John In Palmer" wrote in message
> Thank you so very much.
> "strive4peace" wrote:
>> Hi John,
>> if you are using code to execute the query, use
>> currentdb.execute "QueryName"
>> instead of
>> DoCmd.OpenQuery "QueryName"
>> if you are using macros or just opening queries from the database
>> window, before you run action queries:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13938-update-query-notifications.html
>> macro action --> SetWarnings --> false
>> macro action --> Echo --> false
>> then, after you run action queries...
>> macro action --> Echo --> true
>> macro action --> SetWarnings --> true
>> Warm Regards,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13938
>> (: have an awesome day
>> MVP Access
>> Remote programming and Training
>> strive4peace2006 at yahoo.com
>> John In Palmer wrote:
>> > Hi all,
>> > Can anyone tell me how to get rid of the annoying messages that pop up
>> > from
>> > within Access when attempting to run an update or delete query? I would
>> > like
>> > to have the ability to bypass those messages. Thank you in advance.