warnings error

[Tom]

I have a macro that runs an update query in access 2007
when I execute the macro I get a warning that I am about to run an update
query that will modify the data in my table
I used to be able in 2003 to set warnings off I believe was what I did to
prevent these from showing. Is there a way to stop this from showing in
2007? I just want the macro to run

Thanks
Tom

 

[Allen Browne]

You can use SetWarnings off in A2007 as in previous versions. If you can't
see it, you may need to depress the Show All Actions button on the ribbon.

A better solution (in any version), might be to Execute the query in code.
That way you don't need to turn SetWarnings off to avoid that message, and
yet you can still know if it succeeded, and even how many records it
affected. For details, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

 

[Tom]

show all actions was exactly what i was looking for...i like your way better
though. Thanks so much for the help!

Tom