Become a Columnist Microsoft Exchange Site Microsoft Support SiteMSDN Exchange Site

   

Subscribe to OutlookExchange
Anderson Patricio
Ann Mc Donough
Bob Spurzem
Brian Veal
Catherine Creary
Cherry Beado
Colin Janssen
Collins Timothy Mutesaria
Drew Nicholson
Fred Volking
Glen Scales
Goran Husman
Guy Thomas
Henrik Walther
Jason Sherry
Jayme Bowers
John Young
Joyce Tang
Justin Braun
Konstantin Zheludev
Kristina Waters
Kuang Zhang
Mahmoud Magdy
Martin Tuip
Michael Dong
Michele Deo
Mitch Tulloch
Nicolas Blank
Pavel Nagaev
Ragnar Harper
Ricardo Silva
Richard Wakeman
Russ Iuliano
Santhosh Hanumanthappa
Steve Bryant
Steve Craig
Todd Walker
Tracey J. Rosenblath
 
 

Link to Search.oft

Here is the new version of the search form. Because many people have asked me, "how I can I search in the public folders and how can I display the found items", I have added these functions to the form. Furthermore, it is a little bit faster and has a shorter search routine implemented.

I have developed this form, because we have over 2600 contact items in our public contact folder. One of my forms had to search through these 2600 items, where the user gives only a part of the contact name (for example he searches all companies with the string "system" and the form lists all contacts with "system" in the first-, middle- and lastname ("Systemhaus GmbH";"ABU Systeme";"Systema AG"...). Now can the user choose which contact he needs. This form works very good and fast.

The problem was that object.find (for example : item.find("[FirstName] =
""Systemhaus GmbH""") method need the exact name of the first-, middle- or lastname and this was unacceptable. Going through all 2600 contacts and compare every name with the search string needs a lot of time. Thats why I had the idea to search for the name which is bigger than my search string and smaller than my search string where the last letter is one more in the alphabetical order.

example : search string : "syste"
lower limit : "syste"
upper limit : "systf" ( e ==> f)

Link to Search.oft


Disclaimer: Your use of the information contained in these pages is at your sole risk. All information on these pages is provided "as is", without any warranty, whether express or implied, of its accuracy, completeness, fitness for a particular purpose, title or non-infringement, and none of the third-party products or information mentioned in the work are authored, recommended, supported or guaranteed by Stephen Bryant or Pro Exchange. OutlookExchange.Com, Stephen Bryant and Pro Exchange shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.

Copyright Stephen Bryant 2008