R
rouennais
Is there a way to have Access automatically notify me when a date is
approaching or has passed?
approaching or has passed?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
George Hepworth
Yes,
There are probably several ways to do this. Whichever one you pick, though,
will offer its own advantages and disadvantages, and it probably needs to be
tailored to the REASON for the notification as well as the SOURCE of the
date(s) for which you want to give your users the notification.
That said, you can create a little function which looks at the date you want
to keep track of and opens message box depending on the proximity of the
date.
I'm reluctant to offer more detail without having a bit more to go on with
regard to the dates in question and how they are to be checked.
There are probably several ways to do this. Whichever one you pick, though,
will offer its own advantages and disadvantages, and it probably needs to be
tailored to the REASON for the notification as well as the SOURCE of the
date(s) for which you want to give your users the notification.
That said, you can create a little function which looks at the date you want
to keep track of and opens message box depending on the proximity of the
date.
I'm reluctant to offer more detail without having a bit more to go on with
regard to the dates in question and how they are to be checked.
R
rouennais
An example of what I'd like it to do is to keep track of due dates within the
database and automatically alert me somehow (the more automatic the
better--something like appointment reminders in Outlook would be ideal) if
one is, say, three days from now.
database and automatically alert me somehow (the more automatic the
better--something like appointment reminders in Outlook would be ideal) if
one is, say, three days from now.
J
John W. Vinson
An example of what I'd like it to do is to keep track of due dates within the
database and automatically alert me somehow (the more automatic the
better--something like appointment reminders in Outlook would be ideal) if
one is, say, three days from now.
You could have a Form opened by the Startup macro, or as a subform on your
startup Form; base it on a Query on the table using a criterion
DueDate <= DateAdd("d", 3, Date())
You'll need some other criterion to exclude records that have already been
dealt with; for instance, if you don't want to see appointments with due dates
in the past (even if they're overdue!) add a criterion
AND DueDate > Date()
John W. Vinson [MVP]
R
rouennais
Thanks--I'll try that.