Form_SearchAllFields

Message Topic Search Topic Options Post Reply Create New Topic Printable Version

   Form_SearchAllFields
Explanatory Notes (Updated on 06-Oct-2009) 
    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:
    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.

Version: Access 2000 file format. 

References: DAO 3.6
Download >>:  uploads/37/Form_SearchAllFields.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version
A.D. Tejpal Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 01 Jul 2008 Online Status: Offline Posts: 148	Quote Reply Topic: Form_SearchAllFields Posted: 21 Sep 2009 at 8:39am
	Form_SearchAllFields Explanatory Notes (Updated on 06-Oct-2009) 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: 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. Version: Access 2000 file format. References: DAO 3.6 Download >>: uploads/37/Form_SearchAllFields.zip
	-- Email: adtp@airtelmail.in