 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / October 2005impossible to update field on completing task
Hi, I have been trying to get a Task field updated while the Task was clicked as Completed. I use tasks which recurrence every day. I wanted to update a User defined field named "Updater" when the task got clicked as Completed. This is however impossible because when I click the task as Completed it disappears and the new one for one day later appears and gets the focus. Only then the status of the task is checked and will always be Completed = False of course. Is there another way to point to this task being completed. marco Not really, once a recurring task is marked complete the next one in the series is generated. You'd have to update the field you want prior to marking the task as complete if I understand what you want.  SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Hi, > [quoted text clipped - 11 lines] > > marco You are right all along, however I want to update this field automatically and not by typing in. So when I click completed the field "Updater" value will become: gUserID & Date() so the guy who Completed the task and the date. How else should this be done than by clicking the Completed checkbox? Marco Could you then trap the DueDate change. So when a user changes the DueDate of a task the ItemChange will see that someone changed the duedate? Marco You can use the Item.PropertyChange event to see when DueDate has changed. I've never tried it but you might be able to trap Completed being changed there too before the old recurring task is completed and a new one is generated. SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Could you then trap the DueDate change. > So when a user changes the DueDate of a task the ItemChange will see > that someone changed the duedate? > > Marco |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.