Triggering a Before Delete warning message


show more Triggering a Before Delete warning message provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Triggering a Before Delete warning message

A Before Delete macro allows you to perform an action right before you try and delete a record. For example, if I scroll down to my navigation pane and open up my Products Split Form. I want to make sure that no one tries to delete any of my products. If they do, then anyone who has ordered one in the past will have errors in their order history. Instead, we want them to uncheck this box to show that the product is no longer active. To set up this Before Delete event, go to the Layout View for the form. Go to the Property Sheet and in the box at the top choose Form, because we want this to be triggered for the whole entire form not a specific field or form part.

I'll click down here in Before Delete Confirm. Now there are two different approaches I can take to this macro. Notice I've got a dropdown and a Build button. Since we're going to generate a message box asking them to uncheck the active check box, if I could use that in more than one form, then I should make it as a stan...

Triggering a Before Delete warning message
Video duration: 2m 49s 3h 43m Intermediate

Viewers:

Triggering a Before Delete warning message provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...