disable alarm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the method to disable an alert or alarm, like when you don't want to
ask the user whether or not to add a record. I've used it before but can't
find it in the MS Access help.
Thanks so much.
 
If you want to remove the messages for all queries, without using the set
warnings, then in the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to know that it will never prompt with the message event when
you are using the queries dirrectly
==================================
if you don't want to use this method, then after you run the update query
you need to set the warnings back to true

Docmd.SetWarnings False
Docmd.OpenQuery "QueryName"
Docmd.SetWarnings True
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
Back
Top