Forms: Adding a Search form to a database

INFORMATION PROVIDED IN THIS DOCUMENT AND THE SEARCH FORM ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED. THE USER ASSUMES THE ENTIRE RISK OF RUNNING THIS SOFTWARE.

© 1999, Terry Kreft and Dev Ashish.
(Thanks to Arvin Meyer, Pete Barnes, and Lyle Fairfield for their suggestions) 

	Download FindRecord.Zip (version 2.6, Access 97 format)
	Download FindRecord2k.Zip (version 2.6, Access 2000  format) (This current version uses the DAO library. Please make sure it's  selected under Tools | References.)

    Often times, it's necessary to provide ad-hoc search capabilities to a database without forcing the end user to use the QBE grid to do so. 

    Such functionality can be provided by including a form in your database which generates dynamic SQL and assigns it to a listbox on the form to show the results.  The form "frmSearch" provided in the zip file is such a form.

    Version 2.6 allows you to export the resultset in Excel, CSV, Lotus, and HTML formats.

Limitations:

• The form only allows searches on non-system  tables and non-action, non-parameter queries.

• A maximum of five fields (duplicates inclusive) can be used in one SQL statement.  However, by selecting  the "Edit SQL" checkbox, additional criteria can be typed directly in the SQL textbox.

• Multiple criteria can only be grouped together (using parenthesis) by directly editing the SQL textbox.