N
nouveauricheinvestments
Hi,
I have a form where a user can select to take responsibility for a
ticket. At that point, the user will be able to view the record and
all other data pertaining to it, but no one else will. I want to set
a safeguard in the event the user forgets about the ticket or goes on
vacation, has an emergency, etc. and cannot complete the ticket or
manually put it back in the queue. I want to code that, after 4 hours
of updating a specific control, an email is sent from the user's
outlook client and then I will run a couple update queries on my
tables. I know how to all of that, but I don't know how to start a
timer that will activate my other code regardless of whether the
application is open or closed and regardless of whether the user is
logged into his front end. Does anyone have any suggestions?
I have a form where a user can select to take responsibility for a
ticket. At that point, the user will be able to view the record and
all other data pertaining to it, but no one else will. I want to set
a safeguard in the event the user forgets about the ticket or goes on
vacation, has an emergency, etc. and cannot complete the ticket or
manually put it back in the queue. I want to code that, after 4 hours
of updating a specific control, an email is sent from the user's
outlook client and then I will run a couple update queries on my
tables. I know how to all of that, but I don't know how to start a
timer that will activate my other code regardless of whether the
application is open or closed and regardless of whether the user is
logged into his front end. Does anyone have any suggestions?