Notify me

  • Thread starter Thread starter Amelia
  • Start date Start date
A

Amelia

I am using the Project management database on Access 2007. I am curious to
know if this is possible:

Can I set it up so that people can be notified when a due date is coming
near? So what I was thinking is if the due date is 7-2-09, a notice would be
emailed on 6-30-09 that they have a task due in 2 days and they need to check
the database. (or something like that)

Thanks for any info!
 
Are you familiar with the "On Timer" event and the "Timer Interval"
properties on the "Event" tab of a form's property page? If so, you can set
the timer interval to 8640000 (once a day) and create a macro or sub
procedure to walk through your records, compare due dates with Now(), and
send an email (using DoCmd.SendObject) to anyone whose material is due in
less than two days.

Obviously, you would need the Due Date and recipient's email address (or ID
into a Contact table that has the email address) available in the form - and
the form has to be open for the timer to run.

If you don't want to keep the form open all the time, the macro or code
could be attached to a command button that you would have to manually execute
- or that would be executed as part of your Form Load or Form Open event (or
Form Current - if you wanted to limit the emails to just those records you
peruse).
 
Thanks Saul, I will look it over. I have not used the "On Timer" property
before. i am fairly new with Access and I am trying to teach it to myself. I
don't have training with SQL either but I have been getting by so far! Thanks
for the advice and I think I can make something work from here. If not I will
be writing back.
 
Back
Top