- forms6i,
- Query Syntax
- SQL
- Microsoft Access
Copy records with Macro to other fields
Hi Expert,
In Access 2016, how can we copy records from one field to another in the same table, with a macro?
In Access 2016, how can we copy records from one field to another in the same table, with a macro?
how can we copy records from one field to another in the same table, with a macro?
in general, try use an Update query, such as:
Update yourTable set yourField = anotherField Where yourCondition = true
to execute it in Macro, try like:
yourSQL = Update yourTable set yourField = anotherField Where yourCondition = true
CurrentDb.Execute yourSQL
or
yourSQL = Update yourTable set yourField = anotherField Where yourCondition = true
DoCmd.RunSQL yourSQL
When/How would you do this? When the user clicks a button, or when some event occurs?
In general, it's a bad idea to duplicate data like this, unless you're copying over a record to set "default" values - that is, you will "duplicate" the data, but you're going to update one or more fields after you duplicate.
-
![]()
SolutionSelect distinct records based on ID regardless of other field differences -
![]()
ArticleCopy Lotus Notes Calendar to Outlook Domain Without Any Hindrance -
![]()
VideoHighlight the Current Record on an Access form with a Yellow background color -
![]()
Cloud Class®Certification: MOS Microsoft Office Specialist - Access 2016 Part 2
-
![]()
received a Solution
I am getting an error "Too Few parameters - Expected 16" in my Access function to copy multiple records. -
![]()
wrote an Article
QODBC: How to use VBA to Disable Non-Updateable QuickBooks® Fields on a Microsoft® Access® Form (Part 2) -
![]()
created a Video
![]()
How To Make a Graph with Microsoft Access
-
Explore Cloud Class® ![]()
Certification: MOS Microsoft Office Specialist - Access 2016 Part 3
Premium Content
You need an Expert Office subscription to comment.Start Free Trial