vba, forms and shared tasks

[pjeffers]

Form has custom fields (text boxes).
you input number in textbox 1 and number in textbox 2
I have vba that computes the total and inputs in custom text box 3

that works fine,

however on a shared task (users use the same forms with same tex
boxes)
it will accept the textbox 1 and textbox 2 but will not run the vb
code to fill in the total? Is this normal behaviour?

thanks pv

 

[Sue Mosher [MVP]]

What VBA event(s) are you using? Show how you're instantiating the parent
object of any event handlers.

 

[pjeffers]

if propItem = "txtTransportationIntrinsicTotal" then
val1 = item.UserProperties("txtTransportationIntrinsicTotal").value
val2 = item.UserProperties("txtTransportationExtrinsicTotal").value
valTotal = val1 + val2
item.Userproperties("txtTransportTotal").value = valTotal

It will save val1 and val2, but it will not calculate valTotal on
*shared users task*
IT WILL WORK FINE ON THE USERS OWN TASKS BUT NOT ON A TASK SHARED T
HIM WITH OWNER RIGHTS

;59792']What VBA event(s) are you using? Show how you're instantiatin
the parent
object of any event handlers.

 

[Sue Mosher [MVP]]

Is this code behind a custom form? (If so, you're in the wrong forum --
outlook.program_forms is the custom forms forum.) If so, then see
http://outlookcode.com/article.aspx?id=67, the section on Forms in Other
Mailboxes.

 

[pjeffers]

I never know which forum to go to. I will repost everything over there

;59835']Is this code behind a custom form? (If so, you're in the wron
forum --
outlook.program_forms is the custom forms forum.) If so, then see
http://outlookcode.com/article.aspx?id=67, the section on Forms i
Other
Mailboxes.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

if propItem = "txtTransportationIntrinsicTotal" then
val1 = item.UserProperties("txtTransportationIntrinsicTotal").value
val2 = item.UserProperties("txtTransportationExtrinsicTotal").value
valTotal = val1 + val2
item.Userproperties("txtTransportTotal").value = valTotal

It will save val1 and val2, but it will not calculate valTotal on a
*shared users task*
IT WILL WORK FINE ON THE USERS OWN TASKS BUT NOT ON A TASK SHARED TO
HIM WITH OWNER RIGHTS.

 

[pjeffers]

It now works correctly when he changed it to allow scripts.
thanks

 

[Sue Mosher [MVP]]

No need. I was just providing that info for your future reference.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

I never know which forum to go to. I will repost everything over there

;59835']Is this code behind a custom form? (If so, you're in the wrong
forum --
outlook.program_forms is the custom forms forum.) If so, then see
http://outlookcode.com/article.aspx?id=67, the section on Forms in
Other
Mailboxes.

if propItem = "txtTransportationIntrinsicTotal" then
val1 = item.UserProperties("txtTransportationIntrinsicTotal").value
val2 = item.UserProperties("txtTransportationExtrinsicTotal").value
valTotal = val1 + val2
item.Userproperties("txtTransportTotal").value = valTotal

It will save val1 and val2, but it will not calculate valTotal on a
*shared users task*
IT WILL WORK FINE ON THE USERS OWN TASKS BUT NOT ON A TASK SHARED TO
HIM WITH OWNER RIGHTS.


Form has custom fields (text boxes).
you input number in textbox 1 and number in textbox 2
I have vba that computes the total and inputs in custom text box 3

that works fine,

however on a shared task (users use the same forms with same text
boxes)
it will accept the textbox 1 and textbox 2 but will not run the vba
code to fill in the total? Is this normal behaviour?