A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , , ,

Outlook 2003 - Custom Templates for Public Folders





 
 
Thread Tools Display Modes
  #11  
Old May 24th 07, 02:22 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook 2003 - Custom Templates for Public Folders

There would be no point in having three text boxes all bound to the Subject field. You would either use unbound text boxes or boxes bound to three separate custom fields.

Your code below would be appropriate only if textbox1 etc. were custom properties. As you probably have the form designed now, it would need to be adjust to use the correct syntax for unbound controls, as shown at http://www.outlookcode.com/article.aspx?ID=38

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
I would assume that these are unbound text boxes, as they are not dependent
upon any Outlook properties. Although would their origin as "Subject" fields
make them bound text boxes?

Based upon your determination of whether they are bound or unbound, should
my code look like this for 3 text boxes?

Function Item_Write()
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox1")
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox2")
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox3")
End Function

Thanks so much for your help, once again!


"Sue Mosher [MVP-Outlook]" wrote:

The first step is to specify whether these are unbound text boxes or whether they are bound to Outlook custom properties. That will determine the syntax you need to use, as discussed at http://www.outlookcode.com/article.aspx?ID=38



"Scott07" wrote in message ...
Hi, Sue,

So I've done a bit of research to better understand what you're talking
about below, but am still slightly confused. As an example, I have 3 text
boxes that I want displayed on the calendar. Each of the fields I've created
in my form are text boxes and they're named textbox1, textbox2, and textbox3.
How would I go about implementing your code below to satisfy my needs?

Thanks again.

-Scott

"Sue Mosher [MVP-Outlook]" wrote:

At its simplest, it would be something like this:

Function Item_Write()
Item.Subject = Item.Subject & " - " & Item.UserProperties("Your_Property")
End Function

although realistically, you'd probably want to do a little more text parsing to handle the case where an item is being saved multiple times.



"Scott07" wrote in message ...
Thank you for your help. I understand what you mean, but am unsure of the
method of doing so. Can you please explain?

"Sue Mosher [MVP-Outlook]" wrote:

You could use code behind the form to append the data from your custom fields to the Subject or Location property. Those are the only text properties that show data in day/week/month views.


"Scott07" wrote in message ...
Hi,

Recently, I have discovered and made use of the ability to create
custom templates for entries into public folders. At our
organization, we use them solely as calendars to illustrate to staff
that, for example, John has a meeting at 10:00a, Sally is out of the
office, etc. However, I would like to have the data entered into my
custom forms displayed on the calendar. For example, by default, when
data is entered into the "Subject" of the public folder, the
information is displayed on the calendar for viewing. However, none
of my custom fields will show this data as the "Subject" field does.
Is there any way to do this with custom templates?


Thank you.






Ads
  #12  
Old May 24th 07, 04:14 PM posted to microsoft.public.outlook.program_forms
Scott07
external usenet poster
 
Posts: 28
Default Outlook 2003 - Custom Templates for Public Folders

Sue,

Per your input, I've recreated my textboxes so that they are now unbound.
My rationale behind binding them to the "Subject" field was to emulate the
"Subject" field's ability to display on the calendar. However, now that they
are unbound, can you please help me with the code to make two textboxes named
"textbox1" and textbox2" display on the calendar, as the "Subject" field
would?

Thank you.

"Sue Mosher [MVP-Outlook]" wrote:

There would be no point in having three text boxes all bound to the Subject field. You would either use unbound text boxes or boxes bound to three separate custom fields.

Your code below would be appropriate only if textbox1 etc. were custom properties. As you probably have the form designed now, it would need to be adjust to use the correct syntax for unbound controls, as shown at http://www.outlookcode.com/article.aspx?ID=38

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
I would assume that these are unbound text boxes, as they are not dependent
upon any Outlook properties. Although would their origin as "Subject" fields
make them bound text boxes?

Based upon your determination of whether they are bound or unbound, should
my code look like this for 3 text boxes?

Function Item_Write()
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox1")
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox2")
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox3")
End Function

Thanks so much for your help, once again!


"Sue Mosher [MVP-Outlook]" wrote:

The first step is to specify whether these are unbound text boxes or whether they are bound to Outlook custom properties. That will determine the syntax you need to use, as discussed at http://www.outlookcode.com/article.aspx?ID=38



"Scott07" wrote in message ...
Hi, Sue,

So I've done a bit of research to better understand what you're talking
about below, but am still slightly confused. As an example, I have 3 text
boxes that I want displayed on the calendar. Each of the fields I've created
in my form are text boxes and they're named textbox1, textbox2, and textbox3.
How would I go about implementing your code below to satisfy my needs?

Thanks again.

-Scott

"Sue Mosher [MVP-Outlook]" wrote:

At its simplest, it would be something like this:

Function Item_Write()
Item.Subject = Item.Subject & " - " & Item.UserProperties("Your_Property")
End Function

although realistically, you'd probably want to do a little more text parsing to handle the case where an item is being saved multiple times.



"Scott07" wrote in message ...
Thank you for your help. I understand what you mean, but am unsure of the
method of doing so. Can you please explain?

"Sue Mosher [MVP-Outlook]" wrote:

You could use code behind the form to append the data from your custom fields to the Subject or Location property. Those are the only text properties that show data in day/week/month views.


"Scott07" wrote in message ...
Hi,

Recently, I have discovered and made use of the ability to create
custom templates for entries into public folders. At our
organization, we use them solely as calendars to illustrate to staff
that, for example, John has a meeting at 10:00a, Sally is out of the
office, etc. However, I would like to have the data entered into my
custom forms displayed on the calendar. For example, by default, when
data is entered into the "Subject" of the public folder, the
information is displayed on the calendar for viewing. However, none
of my custom fields will show this data as the "Subject" field does.
Is there any way to do this with custom templates?


Thank you.







  #13  
Old May 24th 07, 04:45 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook 2003 - Custom Templates for Public Folders

You already know how to set the value of the Subject property to an expression and how to concatenate multiple strings, because you showed those techniques in your earlier code snippet. All you need is the syntax for an unbound control's value, which is covered in the article I suggested. It requires information we don't have -- the name of the page they appear on.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...

Per your input, I've recreated my textboxes so that they are now unbound.
My rationale behind binding them to the "Subject" field was to emulate the
"Subject" field's ability to display on the calendar. However, now that they
are unbound, can you please help me with the code to make two textboxes named
"textbox1" and textbox2" display on the calendar, as the "Subject" field
would?

"Sue Mosher [MVP-Outlook]" wrote:

Your code below would be appropriate only if textbox1 etc. were custom properties. As you probably have the form designed now, it would need to be adjust to use the correct syntax for unbound controls, as shown at http://www.outlookcode.com/article.aspx?ID=38

"Scott07" wrote in message ...
I would assume that these are unbound text boxes, as they are not dependent
upon any Outlook properties. Although would their origin as "Subject" fields
make them bound text boxes?

Based upon your determination of whether they are bound or unbound, should
my code look like this for 3 text boxes?

Function Item_Write()
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox1")
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox2")
Item.Subject = Item.Subject & " - " & Item.UserProperties("textbox3")
End Function

Thanks so much for your help, once again!


"Sue Mosher [MVP-Outlook]" wrote:

The first step is to specify whether these are unbound text boxes or whether they are bound to Outlook custom properties. That will determine the syntax you need to use, as discussed at http://www.outlookcode.com/article.aspx?ID=38



"Scott07" wrote in message ...
Hi, Sue,

So I've done a bit of research to better understand what you're talking
about below, but am still slightly confused. As an example, I have 3 text
boxes that I want displayed on the calendar. Each of the fields I've created
in my form are text boxes and they're named textbox1, textbox2, and textbox3.
How would I go about implementing your code below to satisfy my needs?

Thanks again.

-Scott

"Sue Mosher [MVP-Outlook]" wrote:

At its simplest, it would be something like this:

Function Item_Write()
Item.Subject = Item.Subject & " - " & Item.UserProperties("Your_Property")
End Function

although realistically, you'd probably want to do a little more text parsing to handle the case where an item is being saved multiple times.



"Scott07" wrote in message ...
Thank you for your help. I understand what you mean, but am unsure of the
method of doing so. Can you please explain?

"Sue Mosher [MVP-Outlook]" wrote:

You could use code behind the form to append the data from your custom fields to the Subject or Location property. Those are the only text properties that show data in day/week/month views.


"Scott07" wrote in message ...
Hi,

Recently, I have discovered and made use of the ability to create
custom templates for entries into public folders. At our
organization, we use them solely as calendars to illustrate to staff
that, for example, John has a meeting at 10:00a, Sally is out of the
office, etc. However, I would like to have the data entered into my
custom forms displayed on the calendar. For example, by default, when
data is entered into the "Subject" of the public folder, the
information is displayed on the calendar for viewing. However, none
of my custom fields will show this data as the "Subject" field does.
Is there any way to do this with custom templates?


Thank you.







  #14  
Old May 25th 07, 06:07 PM posted to microsoft.public.outlook.program_forms
Scott07
external usenet poster
 
Posts: 28
Default Outlook 2003 - Custom Templates for Public Folders

Hi, Sue,

Last night, I visited outlookcode.com and spent a few hours trying to solve
my problem, but am still quite confused. Thus far, I've recreated my form
with unbound textboxes and have had no success with my code. As a refresher,
I want to emulate the "Subject" functionality on a public folder (calendar)
so that entries made into the textboxes will display on the calendar as the
"Subject" would. For example, if I wrote test1, test2, and test3 into the
corresponding textboxes, I'd like those three entries to show on the
calendar. If there is another method to do this, I would be open to it. I
just want my textboxes to display on the calendar.

I really appreciate your help in this matter.

Thank you.

  #15  
Old May 25th 07, 06:51 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook 2003 - Custom Templates for Public Folders

What are you confused about? We can give you more instructions, but if they hit the same roadblocks of confusion, that effort is going to be a waste of everyone's time.

At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.

I want to emulate the "Subject" functionality on a public folder (calendar)
so that entries made into the textboxes will display on the calendar as the
"Subject" would.


Note that this is not an issue of displaying data "as the Subject would" but of putting the data you want to display actually in the Subject property.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
Hi, Sue,

Last night, I visited outlookcode.com and spent a few hours trying to solve
my problem, but am still quite confused. Thus far, I've recreated my form
with unbound textboxes and have had no success with my code. As a refresher,
I want to emulate the "Subject" functionality on a public folder (calendar)
so that entries made into the textboxes will display on the calendar as the
"Subject" would. For example, if I wrote test1, test2, and test3 into the
corresponding textboxes, I'd like those three entries to show on the
calendar. If there is another method to do this, I would be open to it. I
just want my textboxes to display on the calendar.

I really appreciate your help in this matter.

Thank you.

  #16  
Old May 26th 07, 01:09 AM posted to microsoft.public.outlook.program_forms
Scott07
external usenet poster
 
Posts: 28
Default Outlook 2003 - Custom Templates for Public Folders

Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.


  #17  
Old May 26th 07, 02:48 AM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook 2003 - Custom Templates for Public Folders

You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.


  #18  
Old May 27th 07, 10:05 PM posted to microsoft.public.outlook.program_forms
Scott07
external usenet poster
 
Posts: 28
Default Outlook 2003 - Custom Templates for Public Folders

Any suggestions on where to find examples for the formula to concatenate my
other textboxes' properties to the Subject property's textbox?

Thank you.

"Sue Mosher [MVP-Outlook]" wrote:

You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.



  #19  
Old May 27th 07, 10:15 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook 2003 - Custom Templates for Public Folders

If you use the formula editor to pick the fields, you'll see the field syntax that formulas take. After that, it's simple string operators.

[YourField] & " " & [YourOtherField]

etc.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
Any suggestions on where to find examples for the formula to concatenate my
other textboxes' properties to the Subject property's textbox?

"Sue Mosher [MVP-Outlook]" wrote:

You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject.

"Scott07" wrote in message ...
Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.


  #20  
Old May 28th 07, 04:39 AM posted to microsoft.public.outlook.program_forms
Scott07
external usenet poster
 
Posts: 28
Default Outlook 2003 - Custom Templates for Public Folders

So you mean something like the following? Would that link the three
textboxes together?

[textbox1]& " " &[textbox2]& " " &[textbox3]

If that's correct and they're linked, how do I tie them to the "Subject"
property?

Thanks.






"Sue Mosher [MVP-Outlook]" wrote:

If you use the formula editor to pick the fields, you'll see the field syntax that formulas take. After that, it's simple string operators.

[YourField] & " " & [YourOtherField]

etc.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Scott07" wrote in message ...
Any suggestions on where to find examples for the formula to concatenate my
other textboxes' properties to the Subject property's textbox?

"Sue Mosher [MVP-Outlook]" wrote:

You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject.

"Scott07" wrote in message ...
Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2003 - Custom Templates for Public Folders Foodbank Outlook - General Queries 1 May 17th 07 03:19 PM
custom forms without public folders and client installation berndsoft@googlemail.com Outlook - Using Forms 1 April 17th 07 05:34 AM
exchange server 2003/ outlook 2002 and 2003 and public folders t north Outlook - Using Contacts 0 March 6th 07 08:18 PM
Keyboard shortcut for custom view in public folders JD2 Outlook and VBA 0 September 7th 06 09:38 AM
Attaching Custom Forms to Existing Contacts in Public Folders jyu1018@gmail.com Outlook - Using Forms 2 August 23rd 06 02:41 AM


All times are GMT +1. The time now is 02:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
CreditCards - Long Island Families - Credit Card - McDonalds - WoW Gold