Solved

display the duplicate record on an acces form

Posted on 2013-11-20
8
500 Views
Last Modified: 2013-11-25
I have an access 2007 form that is based on a query  dealer_trade_expo
SELECT dbo_dealer_trade_expo.accountnumber, dbo_dealer_trade_expo.dealername, dbo_dealer_trade_expo.businessname, dbo_dealer_trade_expo.address, dbo_dealer_trade_expo.address2, dbo_dealer_trade_expo.city, dbo_dealer_trade_expo.state, dbo_dealer_trade_expo.zip_code, dbo_dealer_trade_expo.phone, dbo_dealer_trade_expo.fax, dbo_dealer_trade_expo.email, dbo_dealer_trade_expo.salesrep, dbo_dealer_trade_expo.attending_day1, dbo_dealer_trade_expo.attending_day2, dbo_dealer_trade_expo.special_event1, dbo_dealer_trade_expo.attending_day3, dbo_dealer_trade_expo.attending_1, dbo_dealer_trade_expo.attending_2, dbo_dealer_trade_expo.attending_3, dbo_dealer_trade_expo.attending_4, dbo_dealer_trade_expo.notes, dbo_dealer_trade_expo.Date
FROM dbo_dealer_trade_expo
ORDER BY dbo_dealer_trade_expo.Date DESC;

Open in new window

the data is entered in to the table by both an access form and from a web form on our web site, I have a check on the access form to prevent duplicates from being entered but I don't control the web form and duplicates are being entered, I would like to display the account number of the the duplicate records on the form or a message box that displays the duplicates so they can be deleted, but not sure how to do it.
0
Comment
Question by:skull52
  • 4
  • 4
8 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 39663355
Try to use the Find duplicates query wizard.
0
 

Author Comment

by:skull52
ID: 39663449
I have done that, finding the dups is not the issues I want it to display the duplicate records as I said either on the form or in a message box.

> I would like to display the account number of the the duplicate records on the form or a message box that displays the duplicates so they can be deleted, >
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39663661
What about using the form setting its record source as the duplicate records query?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:skull52
ID: 39663703
Then the form would only show the duplicate records
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39663801
" I want it to display the duplicate records"

You may display the duplicate records for maintenance "....  so they can be deleted, >".

After that you change the record source.
0
 

Accepted Solution

by:
skull52 earned 0 total points
ID: 39664191
I did it with a subform not elegant but it works
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39665069
"I did it with a subform not elegant but it works "

But this comment is not an answer to accept. Explain how did you solve the problem without making use of the ideas presented so far.
0
 

Author Closing Comment

by:skull52
ID: 39674139
Nobody came up with a viable solution
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question