[Example] Investment Tracking (record cloning with macro)

Some examples to be used directly
Forum rules
No question in this forum please
For any question related to a topic, create a new thread in the relevant section.

[Example] Investment Tracking (record cloning with macro)

Postby DACM » Thu Apr 28, 2011 9:34 am

Here's an example database that could be used to track investment transactions for tax purposes.

The real demo here is a macro assigned to a button that clones the current record to a new record. This aids user input accuracy for related buy/sell transactions while selectively reducing overall input redundancy. The Table Control grid aids in selecting a record to be cloned. It became apparent that the Primary Key constraint forced the listing of each column-name in the SQL/macro. This has the added benefit of allowing selected fields to be cloned. For instance, the Date field is not cloned which allows it to default to today's date in new records as setup with SQL in the table structure.

Enjoy!
Attachments
Investment_Tracking.odb
(16.7 KiB) Downloaded 2266 times
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: [Example] Quality Assurance (multiple clones with macro)

Postby DACM » Sat May 28, 2011 8:04 pm

Here's a variation of the same theme (record cloning) in response to a thread requiring partial-record cloning in support of scientific data sampling. The Form features a SubForm used to filter a Table Control (grid) using two linked-fields in common with the MainForm. This example also includes a push-button macro to eliminate records (using SQL) where a particular field in the record is left NULL (empty).
Attachments
Quality_Assurance.odb
multiple cloning plus subform grid filtered by two mainform fields
(14.63 KiB) Downloaded 1491 times
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am


Return to Database Examples

Who is online

Users browsing this forum: No registered users and 1 guest