vba, forms and shared tasks

Status
Not open for further replies.
P

pjeffers

Member
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?




thanks pvj
 
S

Sue Mosher [MVP]

What VBA event(s) are you using? Show how you're instantiating the parent

object of any event handlers.

Sue Mosher

"pjeffers" <pjeffers.3wptba@no-spam.invalid> wrote in message

news:pjeffers.3wptba@no-spam.invalid...

> 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?

> thanks pvj

> > pjeffers
> https://forums.slipstick.com/
>
 
P

pjeffers

Member
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.






Sue Mosher [MVP] said:
What VBA event(s) are you using? Show how you're instantiating the parent


object of any event handlers.




--


Sue Mosher












"pjeffers" <pjeffers.3wptba@no-spam.invalid> wrote in message


news:pjeffers.3wptba@no-spam.invalid...

>

> 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?

>

> thanks pvj

>

>

> --

> pjeffers

> https://forums.slipstick.com/

>
Click to expand...
 
S

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.

Sue Mosher

"pjeffers" <pjeffers.3wpvuy@no-spam.invalid> wrote in message

news:pjeffers.3wpvuy@no-spam.invalid...

> 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?
 
P

pjeffers

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






Sue Mosher [MVP] said:
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.


--


Sue Mosher












"pjeffers" <pjeffers.3wpvuy@no-spam.invalid> wrote in message


news:pjeffers.3wpvuy@no-spam.invalid...

>

> 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?
Click to expand...
 
P

pjeffers

Member
thanks I looked at that link and will test it on my users task.


Thanks again.




Sue Mosher [MVP] said:
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.


--


Sue Mosher












"pjeffers" <pjeffers.3wpvuy@no-spam.invalid> wrote in message


news:pjeffers.3wpvuy@no-spam.invalid...

>

> 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?
Click to expand...
 
P

pjeffers

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


thanks




pjeffers said:
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?




thanks pvj
Click to expand...
 
S

Sue Mosher [MVP]

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

Sue Mosher

"pjeffers" <pjeffers.3wpymy@no-spam.invalid> wrote in message

news:pjeffers.3wpymy@no-spam.invalid...

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

> 'Sue Mosher [MVP Wrote:
> > ;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.


>

>
>> "pjeffers" <pjeffers.3wpvuy@no-spam.invalid> wrote in message
> > news:pjeffers.3wpvuy@no-spam.invalid...
> >> > 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?

> > pjeffers
> https://forums.slipstick.com/
>
 
Status
Not open for further replies.
< OL 2007 Custom Button | If loop not running >
Similar threads
Thread starter Title Forum Replies Date
V Modifying the built in forms with VBA Outlook VBA and Custom Forms 4
G Message template / custom forms and VBA Help needed - inserting info into table Outlook VBA and Custom Forms 3
S Custom VBA forms in Outlook--how to call w/macro? Outlook VBA and Custom Forms 1
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
D VBA - unable to set rule condition 'on this computer only' Outlook VBA and Custom Forms 3
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1
W Can vba(for outlook) do these 2 things or not? Outlook VBA and Custom Forms 2
MattC Changing the font of an email with VBA Outlook VBA and Custom Forms 0
P MailItem.To Property with VBA not work Outlook VBA and Custom Forms 2
P Tweak vba so it can target another mailbox Outlook VBA and Custom Forms 1
A Outlook 2010 VBA fails to launch Outlook VBA and Custom Forms 2
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
TedSch Small vba to kill political email Outlook VBA and Custom Forms 3
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
Z VBA Forward vs manual forward Outlook VBA and Custom Forms 2
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Any way to force sort by/group by on search results with VBA? Outlook VBA and Custom Forms 1
E Default shape via VBA Outlook VBA and Custom Forms 4
A Change settings Send/receive VBA Outlook VBA and Custom Forms 0
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
D VBA code to select a signature from the signatures list Outlook VBA and Custom Forms 3
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
David McKay VBA to manually forward using odd options Outlook VBA and Custom Forms 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S vba outlook search string with special characters Outlook VBA and Custom Forms 1
S VBA search string with special characters Outlook VBA and Custom Forms 1
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
DDB VBA to Auto Insert Date and Time in the signature Outlook VBA and Custom Forms 2
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
F Excel VBA to move mails for outlook 365 on secondary mail account Outlook VBA and Custom Forms 1
B Zoom automatically next email item (VBA) Outlook VBA and Custom Forms 2
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
A VBA Script - Print Date between first email in Category X and last email in Category Y Outlook VBA and Custom Forms 3
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
N Save selected messages VBA does not save replies and/or messages that contain : in subject Outlook VBA and Custom Forms 1
Y Filter unread emails in a search folder vba help Outlook VBA and Custom Forms 0
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3

Similar threads

Top