Could you tell me if it is possible to set part of a database (possibly one
field) to alert me to a task when a particular date has passed. The reason I
ask is that within our Records Management database we would like to enter a
field for review dates of files and if possible a contact name and number for
the person responsible for that file so that when the review date has passed
we will be alerted to carry out the necessary review.
--
Thank you for reading my post. Hopefully you can answer my querie

Sure. For each record you could have an AlertDate. Then when your application
starts up (AutoExec macro) you can run a report (DoCmd.OpenReport) that
queries the database for records with AlertDate<Date() and Status=Active

-Tom.
Microsoft Access MVP

"Shazza" wrote:

> Could you tell me if it is possible to set part of a database (possibly one
> field) to alert me to a task when a particular date has passed. The reason I
> ask is that within our Records Management database we would like to enter a
> field for review dates of files and if possible a contact name and number for
> the person responsible for that file so that when the review date has passed
> we will be alerted to carry out the necessary review.
> --
> Thank you for reading my post. Hopefully you can answer my querie