MS Access : Copy and Paste record by using Button command

[ariffeti]

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.

[NeoPa]

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.

[ariffeti]

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.

[PhilOfWalton]

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

[NeoPa]

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.