Rico said:
I need alarms and reminders for my database. How can I
easily do this? Are there add-ins for calendars and
appointments, etc?
If you're happy with coding, you can do it easily enough -- *provided*
your database is open at the time the alarm is supposed to go off. The
general approach would be to have a form that is opened at startup and
remains open all the time the database is open, and a table that
contains the alarms/reminders and their schedules. In the form, you
have the Timer event set to fire at suitable intervals -- maybe every
minute, maybe every 5 minutes or longer, depending on the resolution you
need. In the Timer event procedure, you open a recordset on a query of
the table that returns all records for which the trigger point has
passed (i.e., the trigger point <= Now()). If the recordset isn't
empty, you dispatch each record and either delete it or update its
trigger point.
As I said, this is all pretty easy. The problem is that none of this
will happen if your database wasn't open at the time an action was due.
