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
drawleigh wrote:
> 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.
|
Similar Threads
