(Q) How can I get rid of the default "You're about to change x
records....." confirmation message when I run an action query?
(A) There are two methods of doing this.
Toggle SetWarnings property before and after running the SQL statement.
Docmd.runSQL "Delete * From tblCustomers"
Use the Execute method in which case SetWarnings is not required.
Dim db As Database
Set db = CurrentDb
db.Execute "Delete * from tblCustomers"