Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Duplicate command button

    I have a question that i need help on. I have a database that i have created with several fields. I want to put a command button in the form that will search for duplicate records. I want the search not limited to dups in one field because i know that there are several fields that will have the came information, but i want to have it search for dups on every field .



    I would like to have this exported out to excel so that i can see the duplicate records.

    help

  2. #2
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear Brettg,

    To find the dublicates in a table ...
    Pless Insert
    Choose query
    Choose find duplicates query wizard

    Choose the table and the field where you want to find the duplicates

    You can add a button on the form to run this query

    Please try and feedback

    Thanks

    Ahmed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Command button code
    By lfolger in forum Forms
    Replies: 3
    Last Post: 03-25-2008, 04:26 PM
  2. Command button for time & date
    By joet5402 in forum Forms
    Replies: 2
    Last Post: 12-20-2007, 02:59 AM
  3. Which duplicate?
    By grgerhard in forum Import/Export Data
    Replies: 1
    Last Post: 05-27-2006, 06:19 AM
  4. command button to filter a subform issue -
    By countdrako in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 11:58 PM
  5. Open a linked subform with a command button
    By flablueeyedblond in forum Forms
    Replies: 0
    Last Post: 11-18-2005, 01:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums