Solved

display the duplicate record on an acces form

Posted on 2013-11-20
8
502 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

726 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