Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Forums > Access
Access Forum

Back to Access Forum

Duplicate Records Upload Images   Link  
Ndubuisi Chibuogwu 
3 months ago
Hello Richard. The duplicate record encounters problems when dealing with records containing primary keys e.g. employee ID or student ID. How can one navigate around this please? The objective is to be able to create a duplicate record and make modifications on it that does not alter the original record. Thanks
Adam Schwanz
3 months ago
Just make a second/third/fourth record and link it to the first. Either in a second table (probably easier) or with another ID field in your current table.

Ndubuisi Chibuogwu
3 months ago
The problem is the records are 12 in number and the duplicate is applied to a form with a subform holding the records. I tried creating a duplicate button but it duplicates the records in the subform but when I make changes to the duplicate records it still affects the records in the base form/table
Scott Axton
3 months ago
Please post screenshots and examples.  Scrub sensitive data out.
To difficult to guess what the problem might be.
Ndubuisi Chibuogwu
3 months ago

Ndubuisi Chibuogwu
3 months ago

Scott Axton
3 months ago
Still need the code.  Nothing here shows the properties or events of the duplicate button.
Did you watch the videos I linked above?
Ndubuisi Chibuogwu
3 months ago
I watched the video and used the command wizard selecting record operations and then duplicate records. As for the events I did not use any event.
Ndubuisi Chibuogwu
3 months ago

Ndubuisi Chibuogwu
3 months ago

Ndubuisi Chibuogwu
3 months ago

Ndubuisi Chibuogwu
3 months ago

Ndubuisi Chibuogwu
3 months ago

Ndubuisi Chibuogwu
3 months ago
The last two messages are the actual nested form that is giving me a problem. There are three forms (the main form, subform and a nested form). The duplicate function works but whenever I modify the records on the duplicate copy it still affects the record from the main table
Richard Rost
2 months ago
Hi there. Without digging through your code to figure out where you went wrong, the problem is probably that the new records have a wrong ID somewhere. This is a fairly complicated thing to do, but I cover how to copy a record with all of its child (related) records properly in Access Developer 24.
Ndubuisi Chibuogwu
2 months ago
Ok thank you for the early response. I will watch the Lesson 24 and see how it can help me out.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Forum Comments

Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Access Forum
Get notifications when this page is updated

Check out these other pages that may be of interest to you:

1/31/2023Group On Top
1/30/2023Association 8
1/27/2023Math in Fields
1/26/2023Association 7
1/25/2023Change Query
1/24/2023Association 6
1/23/2023Association 5
1/20/2023Association 4
1/19/2023Association 3
1/18/2023Association 2

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/1/2023 5:29:18 AM.