Form_VirtualRecordsMatrix
Explanatory Notes
For example, task planner for December would show 31 virtual records, one for each day of the month. If the user makes entries only for 5th and 20th December, only these two records will actually get inserted in the table, while records pertaining to all the 31 days continue to get displayed.
Three styles have been demonstrated in this sample db:
(a) Task planner as per each day of the given month.
(b) Task planner as per half hourly time slots on the given
day.
(c) Bike sales: For each batch of bikes received, a matrix
having number of virtual records matching the batch size (number of bikes received in the
given batch) is displayed. As and when a bike gets sold, ticking the check box
inserts the record in source table with automatic filling in of sale date as
well as sale stamp fields.
Note:
Styles (a) and (b) above use a modified version of calendar
form originally developed by Allen Browne. Following features have been
incorporated while implementing the adaptation:
(a) Use of calendar form as a subform.
(b) Mild highlighting (persistent) of today's date - This is in addition to
strong highlighting of selected date.
(c) Two way synchronization between calendar subform and task planner subform.
Version: Access
2000 file format.
References:
Nothing extra.