Page 1 of 1

[Example] Investment Tracking (record cloning with macro)

PostPosted: Thu Apr 28, 2011 9:34 am
by DACM
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!

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

PostPosted: Sat May 28, 2011 8:04 pm
by DACM
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).