Copy, Paste and Append
What I want the button to do is to look at the main form which has of the transport information, with the subform having of the clients information and then create a new record based on the current one and keep the same client attached to the new record while at the same time on the new record for the main form filling in the pickup and drop off locations for thetransport based on the original record.
So it would take of the pickup information swap it for the drop off information, below are the fields that I have for both pickup and drop off.
Pickup Zip Code
Pickup Phone Number
By the way I am using Microsoft Access 2010 Pro if that helps. I know that there were many changes between the2000 version to now.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I've got a problem with locking down a database and creating a custom toolbar to Paste Append records. The aim is that the user should be able to manually select and copy records from one table to another via the clipboard. When I add Paste Append it is disabled. When I use Paste, it creates a brand new table and pastes all the records in there rather than the one selected. (Also the user isn't even allowed to see the new table as I have intentionally hidden all extraneous windows and functionality). So.at present, I've had to leave the users with instructions to use Ctrl-C and Ctrl-V and remove all ribbons and toolbars, which is less than ideal for many users. I want my cut, copy, paste and paste append
create a NEW record and paste those values into the new record. The new record would then be visible on the form for additional entry.
I can manually copy and paste the entire row from within the table but cannot get it to work any other way. The Duplicate Record function errors.Append Query errors. Working in Access 2010.
Append query won't append to BE table as it did in 2003,
error message unable to append all due to key violations.
BUT I can copy and paste the output into the BE table from the FE database.
This will vastly reduce the amount of work and time spent entering records individually.
The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cellsback from Excel and then paste this range back into the Access table.
Then I plan to perform some minimal chages to the copied Report design. Do I copy/paste the Report itself, or do I copy/paste the Report design?
Microsoft Access append queries are good for adding data to a different table where the data is based upon a selection criteria. However, append queries are not always the most efficient way of adding records to another database. If you need to add all records and fields from one table to another table, the append query is not the best way to do it. Using Copy and Paste options in this case would be the best solution.