Set warnings on/off in queries

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

Guest

by pressing one button am running 3 update queries that would update 3
different fields in 3 different tables at once and would not like to the
warning that you about to update 3 records three times, however I would like
the user to be informed that the following [Fields] in the following [tables]
with [countRecords] were updated.
I have set the warnings as DoCmd.SetWarnings False.

E.g, Should be like
Fields Table Records (This line is just an illustration can be
ignored)

FinalAns tblNo1 5
FinalAns tblNo2 5
FinalAns tblNo3 5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Warnings on/off in VBA 1
Turn off warning message 3
dynamic calculated field in query 3
Query Question 2
Strange warning message 1
Set Warnings false is misbehaving 2
DSum update query with multiple fields 0
Query to group similar number combinations? 4

Back
Top