Bypassing message when running Update Qury

[Guest]

When I run an Update query I receive a message warning me that I am about to
modify data. I click Yes and receive a second message warning that I am
about to Update rows.

Is it possible to suppress the messages so they do not appear when I run the
query?

thanks for any help.

JoeP

 

[Allen Browne]

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html
for a couple of ways to handle this.

 

['69 Camaro]

Hi, Joe.

Is it possible to suppress the messages so they do not appear when I run
the
query?

Yes. Select the Tools -> Options... menu and select the "Edit/Find" tab in
the Options dialog window. Uncheck the "Record changes" and "Action
queries" check boxes in the "Confirm" section (in the top right of the
window), and then select the "OK" button to save the changes.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.