Access 97 pop up alarm

[Alan Paterson]

I would like to be able to have pop up alarms on my database. i.e. A warning
that a date has been reached and an action is required.
I would like this to take the form of a message box giving the user a
warning that an action needs to be taken, perhaps something like checking
the date in a particular field and if one year has elapsed then a warning
would come up telling the user to perform a particular function on this
record.
Any ideas would be very helpful

[David B]

You need something in the on load event of a form in your app, The form that
opens when the db starts probably.

If [datefield] < dateadd("yyyy",-1,date()) then
msgbox "Its over a year since this date, time to worm the cat"
end if

If the [datefield] is not on the form being opened you may need to use Dlookup
to find the value
Hope this gets you going in the right direction
David B

Alan Paterson <al*******************@btopenworld.com> wrote in message
news:bu**********@titan.btinternet.com...

I would like to be able to have pop up alarms on my database. i.e. A warning
that a date has been reached and an action is required.
I would like this to take the form of a message box giving the user a
warning that an action needs to be taken, perhaps something like checking
the date in a particular field and if one year has elapsed then a warning
would come up telling the user to perform a particular function on this
record.
Any ideas would be very helpful

[Pieter Linden]

"Alan Paterson" <al*******************@btopenworld.com> wrote in message news:<bu**********@titan.btinternet.com>...

I would like to be able to have pop up alarms on my database. i.e. A warning
that a date has been reached and an action is required.
I would like this to take the form of a message box giving the user a
warning that an action needs to be taken, perhaps something like checking
the date in a particular field and if one year has elapsed then a warning
would come up telling the user to perform a particular function on this
record.
Any ideas would be very helpful

Alan,
when did you want the alarm to pop up? If you want it to show at
startup, then that's easy. If you have a query that returns any
"actions" that have not been attended to tblAction(AlarmDate,
ActionTask, CompleteDate...), then you could do something like:

1. Use either DCount or a recordset to get a count of records/events
that are due but not completed.
2. If the count>0 then use MsgBox to open a form with just the due
records (just pass a filter to the form in the open event).

If you're doing it when the application opens, then just set the code
in the startup event of your database. If you need it to happen while
the database is open, you'd need to have a timer on a form execute the
steps for you. The timer stuff is at www.mvps.org/access

HTH,
Pieter