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 - ScheduleTracker.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


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

ScheduleTracker.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: ScheduleTracker.mdb
    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: uploads/37/ScheduleTracker.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