Update Query Message Box

[Kronos]

I have a "Marking" function in my database. The function is so that I can mark certain records, then print reports for only those records. When the database is opened I have set it up to run a Query. The query is a Update Query and it unmark all marked records.
However, when the query runs 2 Microsoft Access message box pop up.
the first says "You are about to run an update query that will modify data in your table."
the second one says "You are about to Update # row(s)."

Does anybody know of a way to automatically have yes be chosen on both message boxes so there are no pop ups?

 

[directormac]

in VBA, include the statement

docmd.setwarnings false

before you run the query. More info on this topic in MS Access help.

--Warning Mac

 

[RV]

Don't how HOW you see to it that your query starts, but you can disable these messages in VBA.

Look up "SetWarnings" in Access Help or run a query on the forum on SetWarnings.

RV

 

[Kronos]

Thank you, I must have mist that in help

 

[mresann]

Be careful on the SetWarnings command. It is good practice to included the "SetWarnings True" statement following the processing of the action. Although the command is not SUPPOSED to affect the current application's settings, it has happened in the past for me. Better safe than sorry.