Creating Duplicate Record

Posted on 2012-08-23
Medium Priority
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
  • 3
  • 2
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38325872
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

ID: 38326070
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
ID: 38326334
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

ID: 38326435
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

Jeffrey Coachman earned 2000 total points
ID: 38326728
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

621 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