Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Form_SearchAllFields
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Form_SearchAllFields
    Posted: 21 Sep 2009 at 12:39am


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.
    (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


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.