By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

Access 97 pop up alarm

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
"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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.