VBA, Can't Preview Subject field

Can't Preview Subject field

Author	Message
pb #1 / 6	Can't Preview Subject field I'm building a custom appt form. In the subject field I would like to have info from 2 test boxes together. In the properties menu, i used a combination formula field. I would like to preview this as the subject when i view my calendar, instead of typing it again and again. Do you know what i'm saying. Kinda confusing, but it seems as if the default subject field cannot be modified.
Wed, 31 Aug 2005 02:51:19 GMT

Sue Mosher [MVP #2 / 6	Can't Preview Subject field Do you mean that the formula you added for the Subject property isn't working? If so, what's the formula and did you set it to always automatically calculate? -- 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 Quote: > I'm building a custom appt form. In the subject field I > would like to have info from 2 test boxes together. In the > properties menu, i used a combination formula field. I > would like to preview this as the subject when i view my > calendar, instead of typing it again and again. Do you > know what i'm saying. Kinda confusing, but it seems as if > the default subject field cannot be modified.
Wed, 31 Aug 2005 03:47:36 GMT

pb #3 / 6	Can't Preview Subject field I have 3 test boxes. Last name First name Type of Exam When I key in the 3 boxes, I want the subject field to automatically fill with those fields: Like: Smith, John(MRI Head) This is so I can see it in the subject field when viewing my calendar for the day. I binded a control to a field using: Sub CommandButton1_Click() Item.GetInspecto.ModifiedFormPages _ ("P.2").textbox.ItemProperty = "Subject" End Sub But this flags for a virus and i don't want to use a command button. Any suggestions? Quote: >-----Original Message----- >Do you mean that the formula you added for the Subject property isn't working? If so, what's the formula and did you set it to always automatically calculate? Quote: >-- >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 Quote: >> I'm building a custom appt form. In the subject field I >> would like to have info from 2 test boxes together. In the >> properties menu, i used a combination formula field. I >> would like to preview this as the subject when i view my >> calendar, instead of typing it again and again. Do you >> know what i'm saying. Kinda confusing, but it seems as if >> the default subject field cannot be modified. >.
Wed, 31 Aug 2005 04:33:54 GMT

Sue Mosher [MVP #4 / 6	Can't Preview Subject field We need to know the exact names of the Outlook properties that the three text boxes are bound to. Once we know that, we can help you write a formula that will change the subject. You can get rid of the command button. -- 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 Quote: > I have 3 test boxes. > Last name > First name > Type of Exam > When I key in the 3 boxes, I want the subject field to > automatically fill with those fields: > Like: > Smith, John(MRI Head) > This is so I can see it in the subject field when viewing > my calendar for the day. > I binded a control to a field using: > Sub CommandButton1_Click() > Item.GetInspecto.ModifiedFormPages _ > ("P.2").textbox.ItemProperty = "Subject" > End Sub > But this flags for a virus and i don't want to use a > command button. Any suggestions?
Wed, 31 Aug 2005 05:26:49 GMT

<pb.. #5 / 6	Can't Preview Subject field I want the subject field bound to 3 fields. Here are the names. LNAME FNAME EXAM When I preview the outlook calender for the whole day, I should be able to read: ----------------------- SMITH,JOHN (MRI Knee) ----------------------- Quote: >-----Original Message----- >We need to know the exact names of the Outlook properties that the three text boxes are bound to. Once we know that, we can help you write a formula that will change the subject. You can get rid of the command button. Quote: >-- >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 Quote: >> I have 3 test boxes. >> Last name >> First name >> Type of Exam >> When I key in the 3 boxes, I want the subject field to >> automatically fill with those fields: >> Like: >> Smith, John(MRI Head) >> This is so I can see it in the subject field when viewing >> my calendar for the day. >> I binded a control to a field using: >> Sub CommandButton1_Click() >> Item.GetInspecto.ModifiedFormPages _ >> ("P.2").textbox.ItemProperty = "Subject" >> End Sub >> But this flags for a virus and i don't want to use a >> command button. Any suggestions? >.
Fri, 02 Sep 2005 08:36:05 GMT

Sue Mosher [MVP #6 / 6	Can't Preview Subject field Try adding this code to your appointment form to build the value of the Subject property from your three custom fields when the item is saved: Function Item_Write() Item.Subject = Item.UserProperties("LNAME") & ", " & _ Item.UserProperties("FNAME") & " (" & _ Item.UserProperties("EXAM") & ")" End Function If you prefer to use a formula, with your form in design mode, drag the Subject property from the FIeld Chooser to any custom page. Right-click the resulting text box, then choose Properties and switch to the Value tab. For the formula type in: [LNAME] & ", " & [FNAME] & " (" & [EXAM] & ")" and set the formula to always calculate automatically. -- 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 Quote: > I want the subject field bound to 3 fields. Here are the > names. > LNAME > FNAME > EXAM > When I preview the outlook calender for the whole day, I > should be able to read: > ----------------------- > SMITH,JOHN (MRI Knee) > ----------------------- > >> I have 3 test boxes. > >> Last name > >> First name > >> Type of Exam > >> When I key in the 3 boxes, I want the subject field to > >> automatically fill with those fields: > >> Like: > >> Smith, John(MRI Head) > >> This is so I can see it in the subject field when > viewing > >> my calendar for the day. > >> I binded a control to a field using:
Fri, 02 Sep 2005 21:10:02 GMT

Page 1 of 1

[ 6 post ]