Run Update Query from Macro witout displaying Update Warning Box

  • Thread starter Thread starter Jasper de Bruin
  • Start date Start date
J

Jasper de Bruin

I want to update some values in a table, using an Update
Query. This query is run from a macro. Now my question is,
is there a way to bypass the two warning boxes that are
displayed when the Update Query is run?

I mean the box that says "You are about to run an update
query that will modify data in your table" and the one
that says "You are about to update XX row(s)"

I want the user not see these boxes as the user must not
be scared by some warning box that he or she may not
understand.

Is this possible without using the Tools > Options menu
option in Access?

I saw somewhere that it is possible, but they didn't give
a solution.

Thanks a lot!
 
Use the SetWarnings macro action (argument: No/False) to disable the
warnings, run your Update, the use SetWarnings macro action again (argument:
Yes / True) to set it back.
 
Thanks man, it worked!
-----Original Message-----
Use the SetWarnings macro action (argument: No/False) to disable the
warnings, run your Update, the use SetWarnings macro action again (argument:
Yes / True) to set it back.

--
HTH
Van T. Dinh
MVP (Access)






.
Click to expand...
 
Back
Top