I am trying to run an Append Query with Primary Keys (so as to eliminate duplicate records). Problem is that I would like to automate this in a macro but keep getting a "...can't append all records..." warning message, which requires I press a button to continue. BAH!!

I have tried Tools->Options and unchecked "Confirm Action Queries", with no luck.

Any suggestions?

Set SetWarning to False

I have the same issue, but I don't see any of those options in my menu. When I go to tools -> options in my access window, I don't see an option for confirm action queries or one for SetWarning. Am I looking in the wrong place?

oops, never mind. I see now....set with code.