Access 2000 qurrie formula needed

S

Shazza

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.
 
T

Tom van Stiphout

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
 
Top