Item_Close Event and public folder lists

[Bob Trucchi]

I have an outlook form which is the default form for a public folder.
I update an Oracle database by catching the Item_Close Event. Some of
the fields I save in the database are % complete and status. This all
works fine. The problem I have is I would like to be able to update
the database when someone changes the status (or other fields) using
the list view instead of opening the form. Is this possible? If not is
it at least possible to make it so the list view is read only on this
folder?

Thanks.

 

[Guest]

You can use the event change to submit changes to the
database:
Sub Item_PropertyChange(ByVal Name)
End Sub

And for custom fields
Sub Item_CustomPropertyChange(ByVal Name)
End Sub

 

[Sue Mosher [MVP]]

Try using the Item_Write event handler instead of Item_Close.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm