Creating Duplicate Record

Posted on 2012-08-23
Last Modified: 2012-08-27
I used the button wizard in Access 2007 to allow my user to create a duplicate record,  The new record gets created successfully however when they close the form , they get a message that data has been copied to the clipboard and do they want to save it or not.

Is there a way to suppress that message?
Question by:seamus9909
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    I cannot replicate this issue.
    I tried a Macro and VBA code.

    Can you post a simple generic example of this database that exhibits the issue?

    Author Comment

    yes look at the form Cases_details. the button is in the header.

    You will have to refresh the link to the BE.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    AFAICT, the "Duplicate Record" is not designed to handle recordsources as complex as yours.
    SELECT DISTINCTROW, Calculated fields, Multiple tables with multiple Join types, ...etc

    In any event, I played around with the code
    Commented out all the code on the "Old Form"
    Delete the missing VBA Reference to your "Mail Merge" module code
    Compiled the code
    Ran the compact repair utility

    ....Then when I copied a record, I did not get any prompts to "save" any clipboard data.

    Author Comment

    I just didnt incldue the mailmerge module, so I left that reference in. and did want you had did and still same results.  Does trusted Locations have anyting to do with this?
    LVL 74

    Accepted Solution

    Not sure, but the DB should always be in a trusted location.

    Do you have all your Service Packs installed for Office *And* Windows?
    Are you compacting the database and compiling the code regularly?
    Is this an issue on all machines?

    To be sure, here is how I tested this:
    I Opened the form and simply clicked the Dupe Record button.
    The record count went up by one.

    So in your case, test it this way as well.

    It may be that one of the fields you are filling in is of a type that triggers the "Clipboard"...?


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    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…
    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.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now