Nifty Search Form
This Advanced but simple to use Search Form is unbelievably easy to set-up. Just create a query and a subform. Following the comprehensive Video Instructions you can integrate the Search Form into your own database. The Nifty Search Form is one of my “Nifty Access Drop in ‘Nifty Components'” – use it to elevate yourself to “Power User Level” in your organisation!
Video 1 (1:03)
Demonstrates the search form’s features, specifically the option to search for text formatting characters at the beginning, middle, and end.
Video 2 (8:30)
Shows how to change the form to display products or customers, including steps and potential pitfalls.
Video 3 (3:58)
Explains how to search another field (e.g., customer reference). Notes that the form is designed only for text searches, not numbers or dates.
Video 4 (4:12)
Provides a quick setup demonstration of the “Nifty Search Form” from scratch, with minimal narration except for mouse clicks.
Video 5 (00:57)
Demonstrates solving a search problem from Access World Forums using the Nifty Search Form. References a forum thread and includes a YouTube video answer.
Video 6 (2:42)
Examines the code behind the Search Form, focusing on modifications for exact matches and null values. Intended for users who want to alter the code.
Video 7 (4:12)
Continues the code discussion from Video 6, covering updates for exact matches and null values in response to a customer request.
