MS Excel -- Application.DisplayAlerts=False

[Guest]

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

 

[Larry Linson]

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.

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

 

[Guest]

Thank you !!! I couldn't figure out how to turn the warnings off !!! Super
helpful