DoCmd.SetWarnings False

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

Hi,

I got the following warning message,even after I used the
DoCmd.SetWarnings False in my even code.

You are about to delete 200 row(s) from the specified
table.

Once you click yes, You can't undo the command to reverse
the chance. Are you sure you want to delete the selected
records?


Is there a way to suppress this massage ?
Thanks,Jenny
 
If you are deleting records through the interface, include this line in the
form's BeforeDelConfirm event procedure:
Response = acDataErrContinue

If you are deleting records programatically:
dbEngine(0)(0).Execute "DELETE ...

Other alternatives include unchecking the 3 boxes under:
Tools | Options | Edit/Find | Confirm
 
Hi Allen,

Thank you very much for your help. I used your solution
in BeforeDelConfirm event, it works perfectly.
Thanks,jenny
 
Back
Top