Crosstab_CalendarStyleTaskPlanner.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 09 Jul 2008 at 11:08pm |
Crosstab_CalendarStyleTaskPlanner Updates: This sample db demonstrates a task planner. On selection of person, year and month, a wall calendar matching the month/year gets displayed. The user can enter planned tasks directly into this calendar. As the space available in each date cell of the calendar is limited, supplementary remarks can be entered in a memo field displayed in a large text box at bottom of calendar. As the user moves into a date cell, control source for this memo field text box gets dynamically re-assigned so as to match the selected date. Active date cell gets highlighted in light yellow back color, matching that of the remarks text box. As and when desired, latest status of data entry in this calendar, which is in crosstab format, can be saved back to the source table in normalized manner, by clicking the Save button which becomes enabled whenever the form gets dirty. For the given person and month/year, calendar report gets generated by clicking the appropriate command button. This report displays the status of task planning for the selected month/year just like a wall calendar. While individual date cells in the calendar show brief mention of planned tasks, date-wise supplementary remarks are displayed at the bottom of report. Note: While entering data in date cells, it would be preferable to keep it brief so as to fit in the limited display area. Supplementary remarks for each date can be entered in the large text box (representing a memo field) at bottom. Version: Access 2000 File Format Reference: DAO 3.6 Download File >>: uploads/37/Crosstab_CalendarStyleTaskPlanner.zip |
|
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 |