Base: How to Duplicate a Record

users
#1

I cannot find a method for duplicating a single record or row in a Base table or form. I want to create new records that contain data from an existing record. Any suggestions?

Cheers,
                  tod

Tod Hopkins
Hillmann & Carr Inc.
todhopkins-at-hillmanncarr.com

#2

Hi Tod,

I cannot find a method for duplicating a single record or row in a Base table or form. I want to create new records that contain data from an existing record. Any suggestions?

Look up clone / copy a record in Base in the openoffice.org user forums:

http://forum.openoffice.org/en/forum/viewtopic.php?f=39&t=51613

Alex

#3

Following method works pretty good for me:

- open your form;
- use the filter (one of the icons on the bottom right of the form window) to select the existing record to duplicate (or to select a small set of records including the intended one);
- activate an additional table view (one of the icons on the bottom right of the form window): the selected record(s) appear(s) on top of your form;
- simply select the row you want to duplicate (click the green arrow left of the row) and drag it to the bottom of the additional table view (the bottom of this table view contains an empty row marked with the yellow star icon "Insert a new record").

NB: opening the additional table view without selecting records, and trying to duplicate directly last row of the table does not work, presumably because of to many records. After selection of records, it works every time for me. I don't know if there is a maximum number of records to allow in the selection.

Hope this helps,

     Paul

#4

To Alex: How does that apply to Libre Office, or does it still?

#5

Hi John,

To Alex: How does that apply to Libre Office, or does it still?

To the extent that OO Basic and LO Basic are substantially the same, the
macro should work. Do note however, that LO4.1 changed the Basic
structure for a date compared to what is used in (A)OO, so if you had
dates to clone, you might possibly have to take account of that.

For the variant that doesn't require a macro (also discussed in the same
thread of the link I posted), it should work in the same way.

Alex

#6

I did try dragging in the table view, but I probably did not have a record selected via filter. Thanks for pointing that out specifically. Will try again.

cheers,
             tod