|
|
Problem with advanced search on custom field w/ formula
Hi,
I have a custom field named "searchcriteria" of type formula where initial value is set to: MyField1&" "&MyField2&" "&MyField3 and option "calculate formula automatically" is set. When I run the form, field "searchcriteria" displays the values as expected. However when I attempt to use Outlook advance search and select custom field "searchcriteria" as criteria, Outlook gives me all items as result even if they don't match the criteria entered. Anyone has any ideas how to troubleshoot? -- Thanks in advance Bodo |
Problem with advanced search on custom field w/ formula
A better approach would probably be to search on the constituent fields, rather than on the formula field.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Bodo" wrote in message ... Hi, I have a custom field named "searchcriteria" of type formula where initial value is set to: MyField1&" "&MyField2&" "&MyField3 and option "calculate formula automatically" is set. When I run the form, field "searchcriteria" displays the values as expected. However when I attempt to use Outlook advance search and select custom field "searchcriteria" as criteria, Outlook gives me all items as result even if they don't match the criteria entered. Anyone has any ideas how to troubleshoot? -- Thanks in advance Bodo |
Problem with advanced search on custom field w/ formula
Hi Sue,
thanks for your post. Now I use the forms Item_CustomPropertyChange event to set the value of my userdefined field (Type Text) by concatenate the 3 customs fields. Advanced search on that udf works fine. -- Thanks in advance. Bodo "Sue Mosher [MVP-Outlook]" wrote: A better approach would probably be to search on the constituent fields, rather than on the formula field. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Bodo" wrote in message ... Hi, I have a custom field named "searchcriteria" of type formula where initial value is set to: MyField1&" "&MyField2&" "&MyField3 and option "calculate formula automatically" is set. When I run the form, field "searchcriteria" displays the values as expected. However when I attempt to use Outlook advance search and select custom field "searchcriteria" as criteria, Outlook gives me all items as result even if they don't match the criteria entered. Anyone has any ideas how to troubleshoot? -- Thanks in advance Bodo |
Problem with advanced search on custom field w/ formula
Yes, that's another good solution.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Bodo" wrote in message ... Hi Sue, thanks for your post. Now I use the forms Item_CustomPropertyChange event to set the value of my userdefined field (Type Text) by concatenate the 3 customs fields. Advanced search on that udf works fine. -- Thanks in advance. Bodo "Sue Mosher [MVP-Outlook]" wrote: A better approach would probably be to search on the constituent fields, rather than on the formula field. "Bodo" wrote in message ... Hi, I have a custom field named "searchcriteria" of type formula where initial value is set to: MyField1&" "&MyField2&" "&MyField3 and option "calculate formula automatically" is set. When I run the form, field "searchcriteria" displays the values as expected. However when I attempt to use Outlook advance search and select custom field "searchcriteria" as criteria, Outlook gives me all items as result even if they don't match the criteria entered. Anyone has any ideas how to troubleshoot? -- Thanks in advance Bodo |
| All times are GMT +1. The time now is 03:35 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com