The sample db demonstrates monthly report in calendar style layout, showing
appointments / tasks scheduled for various dates.
No space is wasted in the data table for storing records for dates where no
appointment or task is scheduled. However, the report shows all days of the month
in question, arranged in calendar style. Days having appointments / tasks are
highlighted in distinct color.
The report is based upon an interesting variation of multi-column layout, avoiding
the need for cross tab query.
It also includes data entry interface, with two way synchronization between the
calendar and data entry subforms:
(a) As the user picks any date on the calendar subform, data entry subform
moves to the record pertaining to this date. If there is no existing record for
this date, the form moves to a new record, having the selected date as its
default value.
(b) While in data entry form, if the user steps through various records, date shown
on the calendar keeps changing in synchronization with the current one on
data subform.
The calendar used for data entry is an Access subform, thus avoiding use of any
OCX control for this purpose.
Versions - Access XP & 2K (both in Access 2000 File Format)
References - DAO 3.6 Download Access XP & 2K: http://www.rogersaccesslibrary.com/forum/uploads/37/ReportCalendarStyle.zip -
|