Checking for duplicates.

[Guest]

I have an issue where I want to check an underling table for duplicates
before I add the current record. I may still want to add it based on certain
criteria, i.e. the problem wasn't corrected the first time through. So I
would type in the info and would see a pop-up box saying this is a duplicate
record, do you want to contuine adding this.

I am thing of using a recordsetclone to do a search based on a line number
that the user would input. but I am not sure of the language beyond setting
up the recordsetclone and making it available in the background.

Also, the pop-up should include a way of actually marking the existing
record as incomplete instead of adding the new record.

Hope you understand where I am going.

Thankd

 

[Shaun]

checking for duplicates is fixing the symptom instead of the cause.

Every table needs a primary-key. If that key is an auto-number long integer
field, then that same table needs a Unique Index formed on one or more
columns that are not the primary key.

Once a unique index is formed on the table, duplicate records are
impossible.

 

[Guest]

To see what the SQL would look like, create a new query using the "Find
Duplicates query Wizard".

Also, you can Google the MS Access group... there are many examples of code
for finding duplicates - enough to get you started.

Here is a link to the group (should be one line):

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.databases.ms-access

Search for "duplicates" or "find duplicates".

HTH

 

[Guest]

This I know, I think my real question is, how would I pull the duplicate
record up so the user can see it immediately while he is enterin the new
record so that he can set a printed property to false so that record can be
reprinted. I work with unique keys all day, but have not been able how to
pull up the old record when the new one is being entered.

 

[Guest]

Thanks for the respnse Steve, I will definitely check this out.