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.

Members

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.

•  Extended Cut Video - Silver
•  Database Template Download - Gold

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!

Links

• Intro to VBA: https://599cd.com/IntroVBA
• Concatenation: https://599cd.com/Concatenation
• InputBox: https://599cd.com/InputBox
• Like Keyword: https://599cd.com/Like
• Search Seminar: https://599cd.com/acs

Update

• Speed Up Search: https://599cd.com/SpeedUpSearch

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.