ReportCalendarStyle.mdb

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: uploads/37/ReportCalendarStyle.zip