View duplicate records side-by-side on a form.

[rwolff]

Is there a way to view duplicate records side by side on a form in Access? Something like a continuous form sideways?

 

[LonnieJohnson]

Other than two smartly placed subforms, I don't think so. Maybe you can pose your problem or reason for wanting to do this and we can figure something esle out.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[rwolff]

Thanks for the response.

I am trying to create (a) form(s) that will show side-by-side 2 duplicate records and enough data to distinguish them. The user would then decide which record to delete. Any records related to the record to be deleted would have to be transferred to the remaining record.

I would also want an option to update the remaining record's empty fields with info on the record to be deleted if it is available.

Am I making sense?

 

[randy700]

I would think you can accomplish the same thing by using continuous forms. Use the wizard, if necessary, to find duplicate records, then base your form on the query. There is nothing to prevent you from editing one record and deleting another -- they just won't show the next time you open the form because they no longer fit the query criteria.

Randy

 

[konacq]

rwolff:

If you just need two forms side by side, why not create one form with two subforms embedded side by side? Use the controls on the main form to index which records are displayed on the subforms, in effect creating a continuous side-by-side form.

Konacq

 

[danvlas]

Hmmm...one strange thought...what if you have 'triplicate' records?

I'd better suggest getting the list of 'multiplied' records in a form to state merely the number of records. Then, one double click would display those records displayed in a normal form, one beneath the other. This way user can really decide what to keep and what to delete...

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[rwolff]

Thanks to all who responded.

I was able to make this work using Mainform/subform with the find dupes query as the recordsource on the mainform and a query based on the above query but where it equals the SSN on Main and does not equal the RecordID on Main.

It will need some tweeking.

Thanks again