Preventing Record Deletion in Microsoft Access. Only Allow Delete if Customer is Inactive.
HTML-код
- Опубликовано: 8 сен 2024
- 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:
RUclips: / @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.
awesome video. great job!!!! can't wait to watch the extended cut!!!
Glad you liked it
Thanks..! Awesome & Helpful Tools
Thank YOU
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.
That's a great idea. Thanks for the tip.
how we can conect to your course
599cd.com/ACB1