How do I set up a database using ticklers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to find out how to set up notifications of actions that need to be
reminded of in an MS Access 2000 database, change the intervals for multiple
reminders, and how to set up so it will send an email automatically to a list
of email address in the column F.
 
One way is to use the macro named Autoexec and it will run every time that
the database is opened. Have a table of items with interval and "last date"
fields. The macro runs a query, checks last date vs interval and macro
condition determines if need to send e-mail and update "last date" field.
 
Back
Top