Can I suppress an Append Query message box?

[KerryL]

I've created a command button that launches an Append query, but I'd like to suppress the message box that appears.

(The one saying "you are about to append ### records to Table XYZ. Do you want to continue?)

Is there a way I can make the append query open, run, and close without the message and ok box appearing?

 

[traingamer]

See thread702-975157

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[ptpaton]

KerryL,

If in code:
DoCmd.SetWarnings False
DoCmd.OpenQuery "YourAppendQuery"
DoCmd.SetWarnings True

If from a macro, use the SetWarnings action before and after executing the OpenQuery method.

Be sure to turn setWarnings back on, or you won't get any warnings before deleting records manually until you close and reopen your db.

-Patrick

Nine times out of ten, the simplest solution is the best one.