DoCmd.SetWarnings

[Frank Dulk]

Because every time that this code is executed, Access comes back me a
message asking if I want to exclude... same tends " SetWarnings=False "???

DoCmd.SetWarnings False
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
DoCmd.SetWarnings True

or

DoCmd.SetWarnings False
DoCmd.RunCommand acCmdUndo
DoCmd.SetWarnings True


I thank all,

 

[Perry]

This would be better:

On Error GoTo ErrHand
DoCmd.SetWarnings False
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
ExitHere:
DoCmd.SetWarnings True
Exit Sub
ErrHand:
Resume ExitHere

Don't forget to use an errhandler in code when you toggle system callbacks.

Krgrds,
Perry