SetWarnings

[BoroLee]

I am writing a procedure, but am having difficulty in turning the SystemWarnings to Off. Can anyone tell me what I need to type ???

 

[Atomic Shrimp]

In VBA, you can suppress error messages with:
On Error Resume Next

and turn them back on with:
On Error Goto 0

But it's not a good idea to use this as a substitiute for proper error handling.

Mike

 

[Fornatian]

I assume you have tried this syntax:

Docmd.Setwarnings False
*Code to Run*
Docmd.Setwarnings True

This should work, but you must setwarnings to true after running the procedure to show then again

Formatian