Flag duplicate entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have table which does allow duplicate names (schedules) but I want to code
the entry form to alert that a duplicate may exist. This way if it is an
actual duplicate of name, day, time, unit, it will flag and we can correct.
Any help is appreciated.
 
Use the "Find Duplicates Query Wizard" and add the fields that would contain
duplicates. You can set a new form based on that query and view the potential
duplicated records in a list.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Auto Matching Duplicates? 0
Duplicate Not Allowed, clear field 12
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
Access VBA DCOUNT problem when two forms are involved 0
Duplicate the record in form and subform 23
delete duplicates 1
get Data Validation to stop, list supplied, duplicate data entries 1
Update existing values incrementally w/UPDATE SQL 12

Back
Top