"Tickler" File

  • Thread starter Thread starter Brandy Tiller
  • Start date Start date
B

Brandy Tiller

I am creating a new database and need to have a "tickler"
file to alert me when a due date is aproaching. How would
I do that?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need appointment tickler for several kinds of appts 1
Create Groupwise Reminder for Access 2
Template to act as a tickler for contracts expiration dates? 0
WHAT IS A QUERY TICKLER? 5
Saving calculated due dates to the table 2
Microsoft Office Access 1
Creating a Tickler file on Outlook 2
Why does Excel create multiple copies of the same file? 2

Back
Top