Topics Search

Copy, Paste and Append

Copy, Paste and Append
Views: 5
I have a Microsoft Access 2010 database, I want to create a button called return trip on my main form which does the following.

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 Name
Pickup Address
Pickup City
Pickup County
Pickup State
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.
Sponsored Links:

More topics


Paste Append not working

I've recently been forced to migrate to Access 2007 (much prefer 2003 unlike Excel and Word!)

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). 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

Copy Paste function is not working when the application is running behide

I have created an application using visual studio 2008. The application is to copy the data from one excel file and paste to another excel file. The problem happen when I try use the copy paste function at the same time in other excel file.(I have opened others excel file before the application start.) I'm noticed the value that I paste is not same from what I copy in the excel file.(the application is running behind and using copy paste function at the same time.) How to hold the value using when copy from excel for the application so that othercopy paste function is not affect it? Or do you have any method to solve this issue? Kelen C

Copy query

In the past, I can copy any existing query and paste as a copy so I can modify based on the old one for a new query. Suddenly I can copy the query but cannot paste into query group as the paste feature becomes grey (not available). What did I do causing paste feature disable?

Failure to make a copy of existing query

In the past, I can copy any existing query and paste as a new copy so I can modify based on the old one for new query. Suddenly I can select copy but the paste becomes grey (not available).What did I do something wrong causing the paste feature disable?

Copy and Paste Select Fields

Trying to Copy selected fields from Current Record in Form [ENTRY]. The Table [INSERTS] has a AutoNumber field which appears to prevent copying and pasting the entire record. The preferred method would be to copy select fields
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 Access 2007

Converted FE and BE to Access 2007 from 2003.

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.

Copy and Multiple Paste

I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records.

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.

Copy & Paste ACCESS Report Design

I need several Reports which are very similar to each other. I have designed the first Report. Now I want to know how I can copy & paste the first Report so that I can generate several other identical Reports.

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?

Copy and Paste macro

I need to create a short cut menu in 2007 that will have the copy and paste command. I went to Access help and it showed how to create a shortcut menu using a macro but when I attempted to create this macro I could not find copy or paste in the ACTION column. I also looked in the RunCommand Action arguments and did not find them. I have hidden all the default menus and ribbons but now I need to create a shortcut menu to copy and paste and attach to a form

Creating an Append Query in Microsoft Access

A Microsoft Access append query adds (appends) records from the database table that you are using to another database table. If you are wanting to append records in a database, the table that you want to append records to must exist. Records can be appended to a table in the current database that you are working in, or into another Microsoft Access database.
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.