You need to do a couple things to make this work.
First, setup a query that tests the due date for records in your table minus
whatever number of lead days you want to be notified in advance. Make sure
this query works exactly the way you want it to and that it shows you all
the records you want.
Next, the simplest way to make this work is to setup an autoexec macro in
Access that fires every time this database (mdb file) is opened. Of course
this means that you need to open the database everyday in order to see
anything.
In addition to this you could use the Windows scheduler program (in Windows
XP its called Scheduled Tasks) to open this specific database automatically
each day. Of course, this depends on the computer being on all the time, or
at least when your schedule says you want it to open Access.
Good luck!
Earl
