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:
• Preventing Deletion - ...
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Prev...
LINKS:
Don't Delete: 599cd.com/Dont...
Intro VBA: 599cd.com/Intr...
MsgBox: 599cd.com/MsgBox
Relationships: 599cd.com/Rela...
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, soft delete, dont delete, mark inactive, prevent deletion, allow deletions, allow deletes, die, retire, move out of area, referential integrity, cascade deletes, vba, on delete, delete button, me.allowdeletions, inputbox, password, delete child records, delete orders
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Preventing Record Deletion in Microsoft Access. Only Allow Delete if Customer is Inactive.
Пікірлер: 10