MS Outlook – assigned message (MS Outlook & VBA)

Topic

New Reply

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.

Reply | Quote

Replies

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?

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote