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.
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.
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
