Help in task escalation programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Perhaps this is too complex of a programming issue to discuss in this forum, but I will give it a try. I am looking to create a task-driven database, that will test for a timely response, and if no response is found, reissue the task. If after a couple of retries, no response is found, the task escalates to a secondary person.

What I am basically looking for is how to programmatically create a "NAG", so if something is not completed, a friendly reminder is generated. If no response happens yet again, the responsible party is nagged again to complete a task, and the person's supervisor is forwarded the message.

I am looking to do this reporting through email, basically via Exchange/Outlook and SendObject in Access. Granted this may be beyond simple programming, but I thought this would be the place to at least get some good ideas as to how/if to proceed. Any information would be greatly appreciated!
 
This depends on how often you want to NAG. If this is a
daily NAG, run a query daily against your tracking
table. Select all uncompleted records from the table.
Do a DateDiff function on the initial date to the current
date. If it is 1 or 2 days, remind the original person,
if it is 3 or more days, remind the supervisor. Be sure
to account for weekend or non-work days befor moving up a
level.

If you need same day time NAG's, add a time field and
check how long it has been since a response. You could
also use a timer event on a form to trigger running the
query.

See the Access Help file about the DateDiff function and
the Timer Event on a form.
-----Original Message-----
Perhaps this is too complex of a programming issue to
Click to expand...
discuss in this forum, but I will give it a try. I am
looking to create a task-driven database, that will test
for a timely response, and if no response is found,
reissue the task. If after a couple of retries, no
response is found, the task escalates to a secondary
person.
What I am basically looking for is how to
Click to expand...
programmatically create a "NAG", so if something is not
completed, a friendly reminder is generated. If no
response happens yet again, the responsible party is
nagged again to complete a task, and the person's
supervisor is forwarded the message.
I am looking to do this reporting through email,
Click to expand...
basically via Exchange/Outlook and SendObject in Access.
Granted this may be beyond simple programming, but I
thought this would be the place to at least get some good
ideas as to how/if to proceed. Any information would be
greatly appreciated!
 
Back
Top