Posted on 2011-05-03
On each sub, I start the routine w/ docmd.SetWarnings(False) and pair the original statement with DoCmd.SetWarnings(True) at the end of the subroutine before Exit Sub. I checked each sub to make sure I did not toggle / mix up the True and False settings; yet, when I run the app, I still get confirmattion requests to APPEND data and DELETE records on various functions. It does not occur for all DoCmd.RunSQL(str_SQL) statements, just on a few.
What other rules, besides pairing the two SetWarnings statements, do I need to follow to make sure that this app doesn't require user confirmation?