By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

MS Access : Copy and Paste record by using Button command

P: 2
Hi,
Really need help. I have a form. I want to copy a record and paste it to another field by using button command. (In the same record id).

please refer to the attachment.
Thank you.

Attached Images
File Type: jpg photo_2017-11-21_00-05-12.jpg (66.9 KB, 560 views)
Nov 20 '17 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,419
I suspect your main problem is you don't really understand what you're working with. I can't help with that but I can say if you have controls on a form then you can assign the value of one control to another in VBA code quite easily.

I strongly suggest you work out what you want to do before trying to get it to work. Until you get that far you won't even recognise a correct answer even if you were to see one. FYI You can't use the clipboard to copy/paste information across multiple controls.
Nov 21 '17 #2

P: 2
Thank you. Sorry can't explain correctly. I am not good in VBA.

I have OLD data (3K employees) which the ADDRESS has been updated/corrected.

and Now, I received NEW same data with additional new records (total about 8K employees). Can say additional 5K new employees. This new data come with incomplete ADDRESS that need to be corrected (as what has been done to the OLD data).

So, I have combined OLD(3K) and NEW(8K) data by using Query function which is about 3K records are same. Only the ADDRESS not the same.

Instead of using Ctrl+C and Ctrl+V, i prefer using BUTTON that easier/fast to copy ADDRESS to new address field. This NewADDRESSField should be the best/latest address for the employees.


So, I have created NewADDRESSField for the latest address.
BUTTON function is to COPY from OLD/NEW employee's ADDRESS record and PASTE it to NewADDRESSField record.

Thank you.
Nov 21 '17 #3

PhilOfWalton
Expert 100+
P: 1,430
Do you have any exactly matching data in the Old & new tables (EmployeeID would be perfect, or First name, Last Name & Email would be nearly perfect as would a Mobile phone number?

If so you can do an update query and save a lot of work.

Phil
Nov 21 '17 #4

NeoPa
Expert Mod 15k+
P: 31,419
I suspect Phil is on the right lines. The closer attention you pay to him and work with him the better help you will get.

I appreciate English can be a struggle but so will Phil so let him guide you.
Nov 23 '17 #5

Post your reply

Sign in to post your reply or Sign up for a free account.