Can reminders or notices be set in Access 2000?

[Guest]

I am trying to track time sensitive materials in access and was wondering if
alarms/notices/reminders can be set on records that have dates/times as part
of the data or is there a way to link the data to a calendar that will send
reminders.

 

[Guest]

There are a lot of ways to do this. How you do it will depend on your needs.
If it is sufficient to check for reminders only when you open the database,
then put some code in your startup flow that will read the table with the
dates to find the reminders. If it needs to be more frequent, then set a
timer event to check periodically.

You can then programmatically compose and send E-mail messages to whomever
needs the reminder.

 

[David C. Holley]

Yes and yes.
First and simply, it is possible to have Access create and manage task
items in Outlook. Its just a matter of learning the Outlook object model
which if you've done any VBA programing in Access won't be too
difficult. Snoop around in the MS Knowledge Base and/or the internet and
you should find plenty of information on automation.

Second, in a one of my first databases, I created a form which displayed
information pertaining to when a client was last contacted. It was a
matter of capturing when the file was last modified and then subtracting
that date from today's date to get the age and then sorting descending -
the oldest would be displayed first. Applying this to your situation,
you could create a form that lists records continuously that require
attention. When a user opens the DB, the form would be automatically
displayed.

David H