?
Solved

display the duplicate record on an acces form

Posted on 2013-11-20
8
Medium Priority
?
504 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…
Suggested Courses

762 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