Alert to all users

[sindhuja]

Hi All,

I have a form with series of deadline activity that needs to be met at the specified time. All i want to give alert to all the users 15 mins prior to the turnaround time (if activity not completed).

Else if the deadline met then we nee to select "yes" in the combobox. Also have another form used by different user who has to check for the deadline activites. If "yes" in form 1 then textbox in form 2 should have a value "verify" on the formload or by using refresh button.

Is this possible. I tried using the after update event of combobox in form1 and showing the value only when both the forms are opened by the same user in a same system...

Any guidance on this...

-Sindhuja

[CreganTur]

Is this turnaround time a set daily time, or is it a calculated value based on some other information in the table or on the form?

Here are a couple of articles that dig into the Timer event for Forms. They give a lot of information on what the timer is and how it can be used. Maybe this can help you:
Access VBA Timer Event (http://www.bluemoosetech.com/microsoft-access-vba.php?jid=8&title=Microsoft%20Access%20VBA%20Timer%20Event)
VBA Timer Event Example (http://www.blueclaw-db.com/access_event_programming/timer.htm)