By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

Avoiding Access Deletion confirmation messages

stonward
100+
P: 145
Hi again Guys,

I've manages to recreate some fairly cool (to me!) delete code to delete a record. However I'd like to stop the Access 'confirmation of delete' message from appearing. Is this possible?

Good to talk with y'all again.

StonwardR
Oct 7 '08 #1
Share this Question
Share on Google+
3 Replies


stonward
100+
P: 145
Stop the Presses!

I'm sorry if I wasted anyone's time but I seem to have finally found the answer (set warnings).

I promise I DID search before I posted - just that more searching eventually got me there.

Thanks and talk with you again no doubt.

StonwardR
Oct 7 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
Glad you found the answer! Remember to always place the

DoCmd.SetWarnings False

***immediately*** before the event and

DoCmd.SetWarnings True

***immediately*** after the event.

Also, you need to realize that if your code errors out between these two points, the warnings will not be set back on! If there's any chance at all of a piece of code erroring out, you need to set the warnings back on in your error handling code for the sub.

Linq ;0)>
Oct 7 '08 #3

stonward
100+
P: 145
Thankyou, Linq,

The additional notes have been a seriously good help, and probably prevented some fairly awful results.

Thanks again.

StonwardR
Oct 9 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.