Print Page | Close Window

ScheduleTracker.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=35
Printed Date: 20 Oct 2017 at 10:17am


Topic: ScheduleTracker.mdb
Posted By: A.D. Tejpal
Subject: ScheduleTracker.mdb
Date Posted: 06 Jul 2008 at 10:59pm
1) This sample db tracks following types of events -
        (a) Recurring (Birthdays, Marriage Anniversaries etc)
        (b) Others -
            (i)  Scheduled Appointments/Court Cases etc
            (ii) Periodical Project Reviews Etc
2)  Whenever the database is opened, there is an automatic pop up display if 
         any event happens to fall in the Alarm Zone. Criteria for inclusion in Alarm 
        Zone is as follows -
        (a) For recurring type - From one day before current date, upto a week ahead.
        (b) Others (only where the check box for RemStatus has been selected)- All 
            due dates already crossed as well as those falling within a week ahead of
            current  date. In case of scheduled appointments, if any advance notice (in 
            days) has been specified, the due date is computed accordingly. For 
            periodical reviews, if any reminder interval (in days) has been specified, the 
            next due date (which may fall on or after the current date) is calculated 
            accordingly.
            Note - Email messages can be sent to the persons concerned by double
                     clicking the Email Address.  Provision has been made for multiple 
                     profiles, covering different persons to whom various tasks pertain.

3) If no event happens to fall in the alarm zone, the user is taken directly to the 
       main switchboard (without any pop up alarm). At any stage, the present status
       of events can be viewed by clicking the appropriate command button.
 
4) The sample is in Access 2000 File Format - developed on Access XP installation.
References - Visual Basic For Applications, Microsoft Access 9.0 Object Library, 
ADO 2.1
 
Imp - In due course, sample data for other than recurring events would tend to get 
obsolete. For the sake of  demonstration, on each opening of db, table 
T_EventsOthers gets populated via action queries in open event of form F_Check. 
(For regular use, this part of code should be disabled).

Download Access 2000: http://www.rogersaccesslibrary.com/forum/uploads/37/ScheduleTracker.zip -




Print Page | Close Window