Auto email send after time period

[dporrelli]

I have a faults database, and have been asked if it is possible for a email to be sent automatically based on certain criteria (even if no-one has the application open) i.e. status = open, but 1 hour has passed, then every half hour until the status is changed.
Not sure if this is possible.
Any help would be much appreciated.

Thanks

 

[TheAceMan1]

How are ya dporrelli . . .

[blue] . . . based on certain criteria (even if no-one has the application open) i.e. status = open, but 1 hour has passed, then every half hour until the status is changed.[/blue]

I understand the criteria but not when you want to send the email . . .

You could use windows [blue]Task Scheduler[/blue] to kick things off by opening the DB. The DB would run [blue]AutoExec[/blue] which would run your code in [blue]VBA[/blue] . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[dporrelli]

Thanks for that.
I'll try and explain a bit better.
It is a fault logging system that we have.
When a fault is entered the status (just a field in the table) is automatically set to open. Then if the status has not changed after 1 hour, an email gets sent to our support desk with to flag up that it has not been dealt with, then every 30 mins after that.
Hope this clarifies what I am trying to do, it is driving me up the wall!!!

 

[TheAceMan1]

dporrelli . . .

OK . . . this prompts one more question . . . Is it your intent to [blue]track multiple faults[/blue] (Status set in multiple records)?

Also, how do you intend to [blue]stop email[/blue] once a fault is corrected (otherwise the email continues)? . . .

See Ya! . . . . . .

 

[dporrelli]

Yes, we will be tracking multiple faults. To stop the emails, the stauts will need to be changed to another value (i.e. in hand, closed etc....)