How do I set up a database using ticklers?

  • Thread starter lost in access 2000
  • Start date
L

lost in access 2000

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.
 
K

KARL DEWEY

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.
 

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

Top