Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - ReportCalendarStyle.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

ReportCalendarStyle.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: ReportCalendarStyle.mdb
    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

Download Access XP & 2K: uploads/37/ReportCalendarStyle.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down