Disable Action Query Warning

EnginerdUNH
StarLounger
Posts: 50
Joined: 14 Aug 2019, 00:12

Disable Action Query Warning

Post by EnginerdUNH »

Hi,

I was wondering if there is a way to disable the action query pop-up in VBA without the user having to set this as their preference?

User avatar
HansV
Administrator
Posts: 75751
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Disable Action Query Warning

Post by HansV »

You can insert a line

Code: Select all

    DoCmd.SetWarnings False
before running an action query, and

Code: Select all

DoCmd.SetWarnings True
after it.
Regards,
Hans