MS Excel -- Application.DisplayAlerts=False

R

Rubble

In Excel I can write Application.DisplayAlerts=False and it stops all of the
alerts from interrupting my code. Is there a similar piece of code in Access
that will stop Alerts from interrupting my programs?

I know I can also control alerts for my copy of Access -- but I want
something that will only control the alerts during specific procedures.

Thanks --

Jim
 
L

Larry Linson

Rubble said:
In Excel I can write Application.DisplayAlerts=False and it stops all of
the
alerts from interrupting my code. Is there a similar piece of code in
Access
that will stop Alerts from interrupting my programs?

I know I can also control alerts for my copy of Access -- but I want
something that will only control the alerts during specific procedures.
Click to expand...

DoCmd.SetWarnings False will turn off the controllable warnings;
DoCmd.SetWarnings True will turn them back on again. Be careful how you use
them -- it isn't as bad as setting Echo off so the screen isn't updated and
forgetting to set it back on, but the lack of warnings where you _want_ them
can be problematical.

Larry Linson
Microsoft Access MVP
 
Top