Skip Alert Dialoge

[DPACAccessWiz]

I have a function that runs an Update Query then an Append Query. Access prompts the user to confirm each action. If the user cancels one or the other I do not get the correct results. The updated records are only true if the Append works.

How do you tell Access not to ask thes questions?

 

[JeremyNYC]

Call DoCmd.SetWarnings(False)

Just set it to true when you're done.


Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[TorF]

Uncheck option in Tools menu => Options => Edit/Find Tab => Action Queries

 

[JeremyNYC]

TorF,

That won't work for multi-user applications, unless you change the setting on every computer. Every time Access is installed. Doing it in code makes sure that it doesn't matter what the user's setting is.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[DPACAccessWiz]

Thank you JeremyNYC. It works like a charm. I am using this in a multi user environment.

Thanks