By Richard Rost 3 years ago
Create a Single-Field Search Button on your Forms. Filter Property.
In this Microsoft Access tutorial, I will teach you how to create a button that you can use to search a single field in your forms. Nice and simple for your users. We will also learn about the LIKE keyword and wildcard searches so you can find parts of a string.
Reis from St. Paul MN (a Silver Member) asks: The people who work in my office aren't computer experts. I'm trying to make my database as simple as possible for them to use. Do you have any tips for creating a real simple search or find button they can click on to find a record? All of those ribbon and right-click commands can be overwhelming, especially for non-computer people.
I'll show you how to search for RANGES of numeric or date values. Specify a start date and an end date, or a min and max value. Use the BETWEEN keyword to search accordingly.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Search Button
Get notifications when this page is updated
|Keywords: TechHelp Access search button, find button, ms access search for record, ms access search button, how do I add a search button in access, basic search button in access form, creating a search button in access form, instant search box in access form, ms ac PermaLink Single-Field Search Button in Microsoft Access|