Warn But Allow
By Richard Rost 6 months ago
Warn but Allow Duplicate Records in Access
In this Microsoft Access tutorial I'm going to teach you how to have the database warn the user if a particular record exists based on a duplicated field such as the phone number but give them the option to either continue adding the record or to open the existing record. We use a little bit of VBA to accomplish this task.
Avery from Alexandria, Virginia (a Platinum Member) asks: There are a couple of different fields that I track a user by in my database. One is their phone number and although I like to try to keep them unique sometimes there are duplicates between two customers, so I don't want to make it indexed (no duplicates). So I'd like to have it where if my user is entering a new customer's record and the phone number is already in the database it warns me but gives the option to either go to the existing record or continue adding the new record. It's not always practical to search up front.
There is no extended cut, but here is the database file:
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Create a duplicate entry alert, popup message altering a duplicate, warn on duplicate record but allow entry, Handling Duplicates
Subscribe to Warn But Allow
Get notifications when this page is updated