How do I set alarms?

  • Thread starter Thread starter Rico
  • Start date Start date
R

Rico

I need alarms and reminders for my database. How can I
easily do this? Are there add-ins for calendars and
appointments, etc?
 
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?
Click to expand...

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.
 
-----Original Message-----
Are there any samples out there that I could download?
Click to expand...
Go the knowlege base and look for sample forms - it will
return a set of maybe 20 forms; at least two have 'timed'
functions which seem to fit.
 
Rico said:
Are there any samples out there that I could download?
Click to expand...

I don't have one myself, I'm afraid. In addition to the KnowledgeBase,
as Bob Dolmetsch suggested, and Google of course, you might start at the
Access Web -- http://www.mvps.org/access -- and look at the various
sites linked to from there. Lots of them have sample databases you can
download.
 
Back
Top