ReportCalendarStyle.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 07 Jul 2008 at 10:32pm |
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
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |