Copying & Pasting within a subform

[Tracey Rylatt]

Hi

I have created a subform which looks like an excel spreadsheet. Is there any way that say, if you have 10 lines already completed with information that you can copy and paste these 10 lines in the same spreadsheet to make 20 lines.
Thanks.

Tracey

 

[MSAccessRookie]

I am not aware of how you can insert records using cut and paste via a form, but my users append one or more records all of the time. Select the record or records that you want to copy, go to the end, select the new ercord line (with the "*"), and paste the records. They will be added to the end.

 

[Tracey Rylatt]

Thank you, think this might be the solution.

 

[gemma-the-husky]

having said that, if you cut and paste records, you may/will have duplicate records in your database - is that what you really want?

it may be better to provide a command button to manage such functionality

 

[NigelShaw]

Hi,

there is a nifty tool on peterssoftware.com that allows drag n drop between fields, forms and subforms.

nigel

 

[Shadow Stewart]

Yes you can copy and paste whole row to new row by simply selecting the whole row click on the tab that is at the start of row then copy it and now select new row and paste.


Shadow Stewart

[url=http://www.widecircles.com]Social Bookmarking Service[/URL]