Crystal has already answered your question, but if you want more detail see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html
--
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
news:23F38D4F-ACBD-49E4-AA57-60FFCF95F2CD@microsoft.com...
> NICE!
> 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
>> Crystal
>> *
>> (: 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.
>>