Message box/e-mail

[Georgina]

I have a field entitled call log time (a date and time field) and another one entitled action time (also a date and time field).

I need to either e-mail or pop up a message box when the action time field is blank and the call has been open for 2 hours. I would then like reminder messages to be sent every hour until the action time field has been populated.

Access application will be open all day, but the user will be using other applications at the same time

Please help as is driving me mad!

Georgina

 

[simongallop]

This might be of no use, but without looking into it in detail, my approach would be:

Start the timer when call log time is entered, so OnChange event of the textbox.

After 2 hours (the timer counts in miliseconds so =7,200,000) open a form which has been set to Modal. I think that this opens in front of other applications, if not then send an email using

DoCmd.SendObject ,,,{EMailAddress},{cc},{bcc},{Title},{Message Text},0

Then reset the timer but this time to 3,600,000 (1 hour)

I have seen a few postings about timers and use of, but if they don't help then post again.

Hope that this is of use to you