|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
March 16th 06, 11:34 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
outlook combobox: value = x if A is selected
Hi....i hope someone can help...i'm going crazy about this
I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann 
|
| Ads |
|
#2
March 17th 06, 01:28 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error).
-- 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 "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
|
#3
March 17th 06, 05:52 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
Thank you Sue for responding.
Maybe this will help: *ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED 01 GHG SH-PR 18.2m 2.73 02 GHG SH-NK 46m 6.00 03 GHG MD-PR 49.4m 7.41 04 GHG MD-NK 45.4m 6.81 05 GHG DB-PR 37.8m 5.67 06 GHG DB-NK 52.6m 7.89 07 COL SH-BT 18.2m 2.73 * The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m so....'item' is selected, but the value is displayed I hope you can uderstand this!! Thanks Ruthann "Sue Mosher [MVP-Outlook]" wrote: How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error). -- 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 "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
|
#4
March 17th 06, 06:11 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
Sorry but that's just gobbledygook the way the news server renders it. Are you saying that all you have is a single list of possible items to select, each one with a corresponding value? That there are in fact no arithmetic calculations to be performed?
-- 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 "redruthann" wrote in message ... Thank you Sue for responding. Maybe this will help: *ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED 01 GHG SH-PR 18.2m 2.73 02 GHG SH-NK 46m 6.00 03 GHG MD-PR 49.4m 7.41 04 GHG MD-NK 45.4m 6.81 05 GHG DB-PR 37.8m 5.67 06 GHG DB-NK 52.6m 7.89 07 COL SH-BT 18.2m 2.73 * The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m so....'item' is selected, but the value is displayed I hope you can uderstand this!! "Sue Mosher [MVP-Outlook]" wrote: How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error). "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
|
#5
March 17th 06, 09:05 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
EXACTLY - I have already calculated what I need - variables will only change
approx once a year - therefore, I do not need Outlook to do any calculations - just display a given amount based upon selection. {sorry about the craziness...just frustrated} RUTHANN "Sue Mosher [MVP-Outlook]" wrote: Sorry but that's just gobbledygook the way the news server renders it. Are you saying that all you have is a single list of possible items to select, each one with a corresponding value? That there are in fact no arithmetic calculations to be performed? -- 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 "redruthann" wrote in message ... Thank you Sue for responding. Maybe this will help: *ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED 01 GHG SH-PR 18.2m 2.73 02 GHG SH-NK 46m 6.00 03 GHG MD-PR 49.4m 7.41 04 GHG MD-NK 45.4m 6.81 05 GHG DB-PR 37.8m 5.67 06 GHG DB-NK 52.6m 7.89 07 COL SH-BT 18.2m 2.73 * The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m so....'item' is selected, but the value is displayed I hope you can uderstand this!! "Sue Mosher [MVP-Outlook]" wrote: How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error). "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
|
#6
March 27th 06, 11:54 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
Sorry for the late follow up. I think the function you'll want to use in your formula is Switch(), which you can look up in VBA Help.
What I'm still vague on is *where* you want this value to appear -- the value that depends on the user's selection in the combo box. -- 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 "redruthann" wrote in message ... EXACTLY - I have already calculated what I need - variables will only change approx once a year - therefore, I do not need Outlook to do any calculations - just display a given amount based upon selection. {sorry about the craziness...just frustrated} RUTHANN "Sue Mosher [MVP-Outlook]" wrote: Sorry but that's just gobbledygook the way the news server renders it. Are you saying that all you have is a single list of possible items to select, each one with a corresponding value? That there are in fact no arithmetic calculations to be performed? "redruthann" wrote in message ... Thank you Sue for responding. Maybe this will help: *ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED 01 GHG SH-PR 18.2m 2.73 02 GHG SH-NK 46m 6.00 03 GHG MD-PR 49.4m 7.41 04 GHG MD-NK 45.4m 6.81 05 GHG DB-PR 37.8m 5.67 06 GHG DB-NK 52.6m 7.89 07 COL SH-BT 18.2m 2.73 * The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m so....'item' is selected, but the value is displayed I hope you can uderstand this!! "Sue Mosher [MVP-Outlook]" wrote: How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error). "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
|
#7
March 29th 06, 04:34 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
The value of the selection would appear in another field, let's say the
'mileage' field. Perhaps I am going about it in the wrong way. Ruthann "Sue Mosher [MVP-Outlook]" wrote: Sorry for the late follow up. I think the function you'll want to use in your formula is Switch(), which you can look up in VBA Help. What I'm still vague on is *where* you want this value to appear -- the value that depends on the user's selection in the combo box. -- 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 "redruthann" wrote in message ... EXACTLY - I have already calculated what I need - variables will only change approx once a year - therefore, I do not need Outlook to do any calculations - just display a given amount based upon selection. {sorry about the craziness...just frustrated} RUTHANN "Sue Mosher [MVP-Outlook]" wrote: Sorry but that's just gobbledygook the way the news server renders it. Are you saying that all you have is a single list of possible items to select, each one with a corresponding value? That there are in fact no arithmetic calculations to be performed? "redruthann" wrote in message ... Thank you Sue for responding. Maybe this will help: *ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED 01 GHG SH-PR 18.2m 2.73 02 GHG SH-NK 46m 6.00 03 GHG MD-PR 49.4m 7.41 04 GHG MD-NK 45.4m 6.81 05 GHG DB-PR 37.8m 5.67 06 GHG DB-NK 52.6m 7.89 07 COL SH-BT 18.2m 2.73 * The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m so....'item' is selected, but the value is displayed I hope you can uderstand this!! "Sue Mosher [MVP-Outlook]" wrote: How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error). "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
|
#8
March 29th 06, 08:26 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
outlook combobox: value = x if A is selected
In that case, you'd put a formula on the Mileage field's control that uses Switch, e.g.:
Switch(Left([YourFieldName], 3) = "01", 2.73, Left([YourFieldName], 3) = "02", 6.0) I'll leave it to you to fill in as many other terms for Switch as you need. -- 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 "redruthann" wrote in message ... The value of the selection would appear in another field, let's say the 'mileage' field. Perhaps I am going about it in the wrong way. Ruthann "Sue Mosher [MVP-Outlook]" wrote: Sorry for the late follow up. I think the function you'll want to use in your formula is Switch(), which you can look up in VBA Help. What I'm still vague on is *where* you want this value to appear -- the value that depends on the user's selection in the combo box. "redruthann" wrote in message ... EXACTLY - I have already calculated what I need - variables will only change approx once a year - therefore, I do not need Outlook to do any calculations - just display a given amount based upon selection. {sorry about the craziness...just frustrated} RUTHANN "Sue Mosher [MVP-Outlook]" wrote: Sorry but that's just gobbledygook the way the news server renders it. Are you saying that all you have is a single list of possible items to select, each one with a corresponding value? That there are in fact no arithmetic calculations to be performed? "redruthann" wrote in message ... Thank you Sue for responding. Maybe this will help: *ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED 01 GHG SH-PR 18.2m 2.73 02 GHG SH-NK 46m 6.00 03 GHG MD-PR 49.4m 7.41 04 GHG MD-NK 45.4m 6.81 05 GHG DB-PR 37.8m 5.67 06 GHG DB-NK 52.6m 7.89 07 COL SH-BT 18.2m 2.73 * The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m so....'item' is selected, but the value is displayed I hope you can uderstand this!! "Sue Mosher [MVP-Outlook]" wrote: How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error). "redruthann" wrote in message ... Hi....i hope someone can help...i'm going crazy about this I would like a combobox that would display a certain $amt based on a selection... Select Bridgeport - the amt of 5.00 appears. For some reason I just can't seem to get it...I've searched all over, but there is something that I am just not understanding. I understand that there has to be data to be referenced agains. My problem is 'populating'....I can add basic selections, but not to the extent for the selection to display a different data. I'm not sure how to add rows/columns... PLEASE HELP Ruthann
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Populate combobox with public folder contact | Pazuzu | Outlook - Using Forms | 4 | March 15th 06 10:27 AM |
| Outlook 2003 doesn't show number of selected items | RD | Outlook - Installation | 1 | March 2nd 06 09:47 PM |
| automatic from combobox | thtsps | Outlook - Using Forms | 1 | February 27th 06 01:44 PM |
| setting default for combobox... | Jim Burke in Novi | Outlook and VBA | 1 | January 30th 06 07:26 PM |
| Cannot start Microsoft Outlook. Unable to display the selected fo | 5Circles | Outlook - Installation | 2 | January 19th 06 04:20 AM |
Linear Mode
