Preventing Record Deletion in Microsoft Access. Only Allow Delete if Customer is Inactive.

In this video, I will show you how to prevent a user from deleting a customer record unless certain conditions are met, for example, the customer has to be marked inactive. If they are still active, they cannot be deleted.

Anderson from North Hempstead, New York (a Platinum Member) asks: We have customers who, for one reason or another, will no longer be customers anymore. They might die, retire, move out of our area, etc. I want to allow my users to delete a customer but only once he's been marked inactive. I feel like this is an extra check preventing them from deleting a customer too easily. What do you recommend?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to handle deleting records that may have related child records in multiple linked back-end tables where you can't rely on referential integrity and cascade deletes. I'll also show you how to require a password to delete a record.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[michaelrstahl]

awesome video. great job!!!! can't wait to watch the extended cut!!!

[moodkn]

Thanks..! Awesome & Helpful Tools

[Stepan_H]

OK.
But how to prevent "unwanted" deleting on datas, user can delete? If you program message box with question "Are you sure?" and buttons "Yes/No", users ususally fall to stereotype and automatically hit "yes". I made small function with parametrs like MsgBox, but using InputBox, when the user must copy a 5-digit randomly generated number. Then she/he can no longer excuse self for making a mistake and clicking "Yes" by mistake. Return value of my function is boolean True/False...
I don't use this everywhere because in some cases it is extremely counterproductive, but there are forms/data, especially where it is not removed often and there is no problem.