DoCmd.SetWarnings False

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
 
A

Allen Browne

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
 
J

Jenny

Hi Allen,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top