Topics Search

Copy, Paste and Append

Copy, Paste and Append
Views: 6
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:

Similar posts...


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

Copy Paste function is not working when the application is running behide Icon
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

Copy query Icon
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

Failure to make a copy of existing query Icon
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 Multiple Paste

Copy and Multiple Paste Icon
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

Copy & Paste ACCESS Report Design Icon
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?

Creating an Append Query in Microsoft Access

Creating an Append Query in Microsoft Access Icon
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.

Error 3211 - locked table?

Error 3211 - locked table? Icon
I took a copy of my backend database file so that I could apply my changes that I had been working on. The first copy I had was given to me. I did a copy and a paste into my area.

I enabled the database to make mods. I recreated my macro and module onto the new database. When I attempt to run it I get the message that my table is locked when I attempt to append the first new field.

My table and or database is not open by anyone but me trying to add some columns.

Using VBA to select/copy xls data into Access

Using VBA to select/copy xls data into Access Icon
I've been trying numerous methods of getting an Excel worksheet into Access 2003 via VBA to no avail. Transferspreadsheet doesn't work (Excel data problems) but manually copying the sameExcel data then Paste Appending into the Access table works fine.

So, what I'd like to do in VBA is to select and copy all the data in the first worksheet then Paste Append into a named table. I'm ok with establishing a connection to Excel and selecting the necessary xls but am stumped as to how you select and copy data in the first worksheet.

Also, but how do you get the name of the worksheet via VBA?

Right Click Context menu: Only Cut, Copy, Paste

Right Click Context menu: Only Cut, Copy, Paste Icon
I have disabled the menu bars including right click menus for my standard users within my application.

However some of the users want to be able to right click a textbox and cut/copy/paste text that way. Personally I never use those, I always use Ctrl-C and ctrl-V, but I guess its a matter of preference.

Does anyone know or have tried to make a simply right click menu, with only the options to Cut/Copy/Paste?

Copy and paste multiple items by using the Office Clipboard

Copy and paste multiple items by using the Office Clipboard Icon
The Microsoft Office Clipboard allows you to copy multiple text and graphical items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an e-mail message, data from a workbook or datasheet, and a graphic from a presentation and then paste them all into a document. By using the Office Clipboard, you can arrange the copied items the way that you want in the document.
What do you want to do?
* Learn more about how the Office Clipboard works
* Turn on the Office Clipboard
* Control how the Office Clipboard is displayed
* Turn off the Office Clipboard
* Copy multiple items to the Office Clipboard
* Paste items
* Delete items from the Office Clipboard