Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2014

    Unanswered: Prevent duplicates before insert

    I have an access 2010 database and am using a datasheet form to insert multiple records into the database. Is there a way, possibly, to prevent it from allowing duplicate records to be inserted before they are committed to the database.

    I would want it to check the column [Ticket_Number] and then give a popup that shows which ticket numbers are duplicates and then reject all of the rows that are trying to be inserted, or just reject the rows that are duplicates.

    If I failed to explain this out correctly please forgive and any help would be greatly appreciated.

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 35
    Key the [tick#] and there will never be duplicates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts