automatic reminder system

[tucker]

Hello,
I have a problem in my access Form. I created this
form in order for people to enter some details regarding
customer orders and make a follow up on the orders.The
form is used by a few specific marketing employees, who
enter their names and then specify the details of the
customer order and they are responsible for following up
the order.

I have a coloumn called 'Last modified on'.I want to
create an auto reminder system. If the 'last modified'
coloumn shows a value that is 1 month old, then the system
should generate an email to the corresponding marketing
employee reminding him to make a follow up for the certain
order.

any suggestions, how??..I am fairly new to Access..so plz
consider this in your replies.

Thanks a lot

Regards,
Tucker.

 

[Guest]

Tucker,

Here is an idea. If you don't have a specific form that loads when you open
your database, you need one. In the On Load Event of that form, run a query
that will look for LastModified dates that are over 30 days old. Put this in
one column of the query:

ToContact: [LastModified]<DateAdd("d",-30,Date())

In the criteria row, enter True

if the query returns a 0 record count, there are no E-mails to send;
otherwise, send the E-mails from here.