Adding an alarm/notification to Access

[Guest]

We have an Access 2003 database for our customers and their custom homes. Our
constant struggle is tracking customers from deposit to delivery. The people
in contract administration need something that’ll keep timelines of all
projects – blueprint deadlines, price adjustments, etc. – and notify them
(alarm) whenever the project goes off course. I there any way o program this
in or is there an add-on to access that would do this.

Thanks

 

[Ed]

David,

Assuming that you have these dates somplace in the database (some
table/field), then it is a matter of comparing that date with the Now()
function to tell you how much time is left. People often put this in the
'Startup' form so when the user opens the database it is the first thing the
user sees.

Ed