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 - Query_MonitorAnnualEvents
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

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


 Post Reply Post Reply
Message Reverse Sort Order
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: Query_MonitorAnnualEvents
    Posted: 08 Jul 2008 at 10:12pm
Query_MonitorAnnualEvents  (Updated: 11-Jan-2010)
Explanatory Notes:
    This db demonstrates tracking of annual events like birthdays, marriage anniversaries etc
    Events Alert:
    Clicking first command button on main switchboard displays such of the events as are due within next 10 days or are already overdue by upto 3 days.
    Events Status At A Glance (All Events):
    Clicking 2nd command button on main switchboard displays all events at a glance. Dynamic sort order is applied in two alternative styles as per user preference:
    (a) Starting 3 days before today.
    (b) Starting with previous month. The month previous to current one is placed at top. For example, if current month is September, the one at top will be August, while the last one will be July.
    (In alternative (b), although first record starts at beginning of last month, it is ensured that if there are any events due within next 10 days or already overdue by upto 3 days, these get positioned at top in the available display window. If no event is currently due / overdue, records for the current month get positioned at top in the available display window).
    Distinct color highlights are provided as follows:
    (a) Overdue by upto 3 days - Pink.
    (b) Falling due on current date - Ochre.
    (c) Due within next 10 days - Light Blue.
    Note: Functions Fn_DaysAhead() & Fn_DaysPast() are used to detect whether an event is imminent or overdue as on current date. Functions Fn_DtRank() and Fn_MonthRank() are used for enforcing dynamic sort order as per style (a) or (b) above.
Version:  Access 2000 File Format
Reference:  DAO 3.6

Download >>: uploads/37/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.