Print Page | Close Window

Form_SearchAllFields

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=517
Printed Date: 21 Oct 2017 at 10:49pm


Topic: Form_SearchAllFields
Posted By: A.D. Tejpal
Subject: Form_SearchAllFields
Date Posted: 21 Sep 2009 at 12:39am

Form_SearchAllFields

Updated On 13-Jan-2012
Explanatory Notes
 
    This sample db demonstrates fast search across whole data source, covering all fields and all records. The search is conducted on all columns in "Across and then Down" style. Based upon space separated search words entered by the user, advanced search capability is provided as follows:
 
    (a) Match field values having any of search words.
    (b) Match field values having all of search words, but not necessarily in the same order as entered in search box.
    (c) Match field values having all of search words, in the same order as entered in search box.
    (d) Exact match of field values against full contents of search box..
 
    As the user types into the search text box, equivalent criteria string gets displayed at bottom of form. Simultaneously, the total number of matches found across the data source gets displayed. In addition, all  matching fields get highlighted in distinct  back color.
 
    Various search options are selectable via an option group. Appropriate command buttons enable the user to find the first or next matching record as desired. A special subroutine ensures that the found record gets displayed at mid-position of the subform window.
 
    Note:
    (a) For optimum speed, search across all fields is carried out in a single pass through form's recordset, by using a master criteria
string combining the conditions applicable to different fields.
    (b) This method eliminates the need for concatenated strings combining the fields on each record, prior to execution of search action.
    (c) Search action takes care of text as well as number type data.

Version: Access 2000 file format.

References: DAO 3.6

Download >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Form_SearchAllFields.zip -
 
 


-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window