Base Copy Field or Clone Record - Example
Jan 30, 2018 10:29:30 GMT 1
Post by michaelmorin on Jan 30, 2018 10:29:30 GMT 1
HI,
From time to time there have been requests to match the MS Access facility whereby pressing a key combination automatically copies to a new record the data recorded for that particular field in the previous record.
A macro is clearly required but, due to the idiosyncrasies of the OpenOffice API, portability encourages coding that eschews references to a named or any object that may be specific to a particular application.
For several years I have used Base for a book-keeping application where often new transactions differ in only minor respects from previous records. A macro has permitted data from any selected record to be cloned to the new record entry buffer where changes may be made before a final save to the database.
In the attached demo that macro has been extended to permit either cloning a whole record or copying a single field from its previous record as found in MS Access. The macro permits either pressing the Alt and ' key combination to copy to any selected field (new or existing) the data from the corresponding field in its immediate predecessor, or pressing the Alt and + (num pad) combination to clone any selected record to the new record row.
For more you can check this
Product Promotional Examples
From time to time there have been requests to match the MS Access facility whereby pressing a key combination automatically copies to a new record the data recorded for that particular field in the previous record.
A macro is clearly required but, due to the idiosyncrasies of the OpenOffice API, portability encourages coding that eschews references to a named or any object that may be specific to a particular application.
For several years I have used Base for a book-keeping application where often new transactions differ in only minor respects from previous records. A macro has permitted data from any selected record to be cloned to the new record entry buffer where changes may be made before a final save to the database.
In the attached demo that macro has been extended to permit either cloning a whole record or copying a single field from its previous record as found in MS Access. The macro permits either pressing the Alt and ' key combination to copy to any selected field (new or existing) the data from the corresponding field in its immediate predecessor, or pressing the Alt and + (num pad) combination to clone any selected record to the new record row.
For more you can check this
Product Promotional Examples