Append Query without asking YES/ NO

[twlew]

I created a button in Form. When click it, it will run the Append Query. Everything works fine, but I don't like those two messages box come up to ask me whether I want to Append xx records to "yy" table. How to HIDE the message boxes ?

 

[RJFost]

On the menu bar, go to Tools -> Options, then click the Edit/Find tab. In the Confirm group, uncheck "Action queries" to stop the messages you referred to.

Me, I uncheck all 3- if I didn't want to do it, I wouldn't have done it...

 

[DreamerZ]

Or use

DoCmd.SetWarnings False

right before the query is run.

DreamerZ