Here's what I would do. I don't think this is something a query would handle to copy/paste data. There is nothing currently connecting the checkpoint and projects table, so how would Access know which info to copy over.
1) Create the new table you want to insert the data with the proper fields...
Is there a reason to copy? Why not just write the original data in the table you want to copy it into? Can you explain you table structure and process to me?
Have the criteria you want to copy display on a form. Then, set a variable for each field displayed that you want to copy. Have the macro change the view to save the information to the other table. Set the fields on the pop-up to your variables.
It's a similar problem I was having...
Thank you JulianKirkness. I ended up figuring it out on my own using a Macro (not a datamacro). For anyone curious, I'll post my code below. All I did was use the ID to set a variable for each value I wanted to copy, created a new record, and set the individual fields to the variables I had set...
I am looking for a way to duplicate the current record (in List view) all but one field (well, technically two - can't duplicate the ID column). I have 25 fields that need to be populated for each entry and a lot of records are similar except for a field or two.
How would I go about achieving...
hey guys, I've never worked in Access before but have been developing a web database for my company the past couple months. We launched it this week and things are going well so far!