New Page 1

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.