Disable Action Query Warning

EnginerdUNH
StarLounger
Posts: 86
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?
Top
User avatar
HansV
Administrator
Posts: 78383
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.
Best wishes,
Hans
Top

Return to “Access/SQL and other database applications”