Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

display the duplicate record on an acces form

Posted on 2013-11-20
8
Medium Priority
?
505 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 31

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 31

Expert Comment

by:hnasr
ID: 39663661
What about using the form setting its record source as the duplicate records query?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

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

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 31

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

618 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