Suppress confirmation pop-ups

[Joe4]

This question is probably so easy, I am embarrassed to even ask it. Nonetheless...

How do you suppress confirmation pop-ups in VBA code in Access? I know that in Excel, you can use "Application.DisplayAlerts = False", but am not sure what to use in Access.

I am using the "DoCmd CopyObject" command to copy a query over to another one, and it keeps asking me if I want to overwrite the original, and the answer will always be "Yes".

 

[dk]

Hello mate,

DoCmd.SetWarnings False

will do this. Don't forget to set it back to true afterwards.

 

[Joe4]

Thanks dk!

I knew it had to be something simple.