Access 2000 qurrie formula needed

  • Thread starter Thread starter Shazza
  • Start date Start date
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.
 
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
 
Back
Top