Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Outlook - assigned message (MS Outlook & VBA)

    I have a form that is asking three different people to start a process and then they will enter their name, date/time and a message in the form. Using a command button I enter the name, date, message into the database. Now I need to figure out a way so that if someone later opens the form it will let them know that someone is already working on this task or that the task was completed.

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: MS Outlook - assigned message (MS Outlook & VBA)

    I think we would need a little more information to help here...

    Where is the information that someone is working on a task held on the computer? Is this in a public folder within Outlook or in a database somewhere (the database you are using perhaps)? Who is updating that progress information and how are they doing it?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: MS Outlook - assigned message (MS Outlook & VBA)

    1. If you are creating a record of who worked on the form and when, doesn't that answer part of your question?
    2. If you add completion check boxes to the form for each task segment, to attest that a section of the task is complete, will that help you with the remaining part of the objective?
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Outlook - assigned message (MS Outlook & VBA)

    By filling out the form I capture all the information that I need. That was fine with me, but now the Dept Manager doesn't want to OPen the form and tab to the section where his group is working on.. Instead, he wants to be informed what is going on just by opening the form.
    1. Tech 1 opens the form, goes to the section/tab for his depmartment and enters the date/time, his name - Using a command button - he updates the database.and starts on completing the process.
    2. 20 min. later Tech 2 logons into his computer and see's the message about a new message/form is waiting for processing. Now, just by the process of open the form, a message pops up telling him that Tech 1 has already started to work on the request. - So Tech 2 can just close the request as someone else is already working on the task.
    3. 1 hr later Tech 3 logons into his computer, and opens the message/form task. By this time Tech 1 has finished the process, so Tech 3 upon opening the form, has a pop up telling him that the Task has been finished.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: MS Outlook - assigned message (MS Outlook & VBA)

    Perhaps you should sneak into his office and remove his copy of "The one-minute manager". Next, he'll want a one page synopsis of "War and Peace".

    This is about design rather than coding - perhaps you could create a status summary tab in the form?
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Outlook - assigned message (MS Outlook & VBA)

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> I already gave them a Status Monitor system. Its a VB6 application that they call up and select the Dept they are in. In the status Monitor it shows all Task related to their Dept,

    Task number, Date/Time Request, Who Requested it, Status (Submit, Work in Progress, Finished), Who is working on the task and when they started to work on it.

    They are just to lazy to open the Status Monitor up.
    Ok, thanks for the input..I'll just tell them it would take to long to design and code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •