Topics Search

Macro to copy a record and paste within a table?

Macro to copy a record and paste within a table?
Views: 95
I have a table of part numbers and associated information. When I add a new part number, I'd like to use a macro that copies a specified older part and pastes it with a specified new part number. I can't seem to find a function that does this
Sponsored Links:

Similar posts...

 

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.
 

Button to copy fields then a button to paste them into another record.

Button to copy fields then a button to paste them into another record. Icon
But I was merely looking as I was not upto the stage of incorporating it. I am now at that stage,

What do I need to do to be able to copy certain fields in one record via a copy butto and then go to another existing record and by clicking another button, Paste, will fill in the copied fields.

I have different fields like:
Survey Date - Which is a date selector.
Surveyor - Which is a combo box.
KitchenRenewYear - Which is a text box.

If Someone was willing to start me off with how to do this then I can use the code for the remainder of the fileds I want to copy.
 

Three ways to programmatically duplicate a table in MS Access by VBA

Three ways to programmatically duplicate a table in MS Access by VBA Icon
Duplicating a table in Access manually is extremely easy - just Copy and then Paste the table object. The three screenshots below copy Products table, and then paste it to make a new table Products_Copy.
 

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.
 

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 vb.net 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?
 

Paste a table into a cell

Paste a table into a cell Icon
I'm trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

I've tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow
 

Display "Totals row" in a form?

Display "Totals row" in a form? Icon
I'm back with another (possibly silly) question:

How do I turn the totals row into an actual record, so that I can display it in a form? It should still function as the totals row, though (so "copy/paste into an empty record" is not what I'm looking for here).

The idea is that when filtering on a salesperson in the form, we'd display all his sales per month and per year (which I've got working fine), but I've been asked if it's possible to display that person's totals as well.

I'd copy/paste the total rows in a separate table, make another form and link the 2 forms, but I was just wondering if it's possible to display the totals row directly into a form. That way I could eliminate copy/paste errors, AND it would automatically be up-to-date.

Bottom line: how (if at all possible) do I display the Totals Row as-is in a form as if it was a regular record?

EDIT: I'm not familiar with VBA, so if the solution requires VBA, please explain it like you're talking to a 3-year-old
 

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?