Hi All !

Thanks for all the help i've been getting here, im making good progress. One day i'll be proficient enough to save some other geek's life :)

Here's what i'm trying to do.

A table has a date column. I want to send out an email to X number of recipients when that date/time e.g Nov 01, 2004 5pm is reached. Is there some way i can use a macro or setup a module with some VB code or some trigger in Access 2000 to send an email when a certain date is reached.

On a similar note, when that date is reached, i want to run a query.

Any views/suggestions?

Thanks!
R :)

1) Is the db always running? If not, how will it run wihen the db is closed?

2) If you have the code to send the e-mail in place, then you need to set a timer event that will run, oh, every so often, maybe once a minute, or once an hour, if the system date/time equals the fieldvalue date/time, then run the macro or vba that sends the e-mail.

3) Same answer to run the query, use the timer event, assuming the db is always open.

If the db is not always open, then you should set up a Scheduled Task, and trigger this stuff off of an autoexec macro.

HTH :cool:

Good suggestions!

How do i actually setup a timer in MS ACCESS ?

DB is not always open, but i can leave it open, no problem with that.

R

in a form go to design view, then open the properties window.

Scroll down the all tab until you come to "timer interval"

this is in milliseconds...so 1000=1 second, 60000=1 minute.

then go to On Timer, and get it to run either VBA or a macro, job done easy peasy