Channel: Computer Learning Zone
Category: Education
Tags: #tutorialcomposite key#msaccessprevent duplicatespreventing duplicates from being enteredhow do you prevent duplicate entry in accessms accesssql how to prevent duplicate entriesprevent duplicate entries#microsoftaccessvba code to prevent duplicate entries in access#howtopreventing duplicate records across multiple fieldshow to prevent a duplicated data entry#lesson#trainingmicrosoft access#help#database#learnms access tutorial
Description: In this video, I'm going to show you how to prevent your users from adding a duplicate product or service to a customer's order in your Microsoft Access database, using something called a Composite Key. Ramiro from Houston, Texas (a Platinum Member) asks: I run an auto detail shop. My database is pretty simple. We have about ten services that we provide. The problem is that sometimes one of my guys accidentally adds the same service twice, which should never happen. Is there a way to prevent this in the database? Silver Members and up get access to an Extended Cut of this video. Members will learn a different method to prevent duplicates. We'll use a little bit of VBA and the DCount function to check if the product is already on the order. If so, we'll ask the user if they want to add it or not. This also allows us to use a custom warning prompt instead of the default system message. MEMBERS VIDEO: youtu.be/_Me3MqXE-LQ BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/PreventDuplicates LINKS: Invoicing: 599cd.com/Invoicing Relationships: 599cd.com/Relationships Relational Combo: 599cd.com/Relational SUGGESTED COURSES: Access Expert 8: 599cd.com/ACX8 Access Expert 23: 599cd.com/ACX23 Access Developer 27: 599cd.com/ACX27 Access Developer 36: 599cd.com/ACX36 OTHER 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/Contacts Order Entry & Invoicing: 599cd.com/Invoicing More Access Templates: 599cd.com/AccessTemplates 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/TechHelp Consulting Help: 599cd.com/DevNet Twitter: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, composite key, prevent duplicates, prevent duplicate entries, How do you prevent duplicate entry in Access, Preventing Duplicates from being entered, Preventing Duplicate Records Across Multiple Fields, How to Prevent a Duplicated Data Entry, vba code to prevent duplicate entries in access, sql how to prevent duplicate entries, ms-access check for duplicates before update, how to avoid duplication of data in database QUESTIONS: Please feel free to post your questions or comments below. Thanks.