Suppress promt in Update Query

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

Guest

I have a macro set up that runs an update query. (macro attached to a button)

I am wondering if there is a way to stop the two dialouge boxes that come up
when the query is run. I don't want to confuse the users.

Not a big deal if it's not possible. I will just tell them to click yes/Ok
 
I have a macro set up that runs an update query. (macro attached to a button)

I am wondering if there is a way to stop the two dialouge boxes that come up
when the query is run. I don't want to confuse the users.

Not a big deal if it's not possible. I will just tell them to click yes/Ok
Click to expand...

If you are Macros, add a macro (SetWarnings = False) just before you
run the query, and another Macro (SetWarnings = True) after you run
the query.
 
Excellent! Thanks!

fredg said:
If you are Macros, add a macro (SetWarnings = False) just before you
run the query, and another Macro (SetWarnings = True) after you run
the query.
Click to expand...
 
Back
Top