Results 1 to 7 of 7
  1. 07-11-2012, 08:21 AM #1
    uronmapu
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124

    How to a button delete duplicate records from a table in Access 2007

    Dear all,

    How to create a button delete duplicate records from a table in Access 2007



    Many thanks
    Reply With Quote Reply With Quote
  2. 07-11-2012, 08:33 AM #2
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    You could try this:
    1. Create a 'Delete Duplicates' query using the Query Wizard.
    2. Create the button and when prompted - choose Code Builder.
    3. In the Code window that opens - put in something like this: DoCmd.OpenQuery "Your_Remove-Duplicates_Query_Name"
    Reply With Quote Reply With Quote
  3. 07-11-2012, 08:44 AM #3
    uronmapu
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    Could you see my attached file and help me?

    http://www.mediafire.com/?jdjugi4y57ju7i2

    Log on:

    username: admin
    password: admin

    Many thanks
    Reply With Quote Reply With Quote
  4. 07-11-2012, 10:43 AM #4
    uronmapu
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    FYI

    http://www.ehow.com/how_5328612_remo...es-access.html
    http://www.techrepublic.com/article/...-query/1043732
    Reply With Quote Reply With Quote
  5. 07-11-2012, 12:18 PM #5
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Can you post your DB here? You might have to zip it. I cannot download it.
    Were you not able to understand my instructions? It's not complicated.
    Reply With Quote Reply With Quote
  6. 07-11-2012, 07:21 PM #6
    uronmapu
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    Quote Originally Posted by Robeen View Post
    Can you post your DB here? You might have to zip it. I cannot download it.
    Were you not able to understand my instructions? It's not complicated.
    I uploaded .mbb file, please see the link below:

    http://www.mediafire.com/?jdjugi4y57ju7i2

    Many thanks
    Reply With Quote Reply With Quote
  7. 07-11-2012, 10:13 PM #7
    uronmapu
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    The link below ok

    http://www.youtube.com/watch?v=amRbEhQWH78
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Delete duplicate records in another table
    By ermcc in forum Access
    Replies: 2
    Last Post: 04-13-2012, 12:53 AM
  2. Delete Duplicate Records Based on Criteria
    By chadd in forum Queries
    Replies: 2
    Last Post: 02-07-2012, 04:24 PM
  3. Delete entire records from a duplicate query based on oldest date
    By dansutherst in forum Queries
    Replies: 3
    Last Post: 05-03-2011, 01:36 PM
  4. A query to delete records that have a combination of only two duplicate fields?
    By jc1234 in forum Queries
    Replies: 1
    Last Post: 05-21-2010, 02:22 PM
  5. Delete duplicate records
    By Zukster in forum Queries
    Replies: 1
    Last Post: 08-26-2009, 03:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums