Microsoft Access Multi-Field Search Form 2.0 New and Improved Features!

0 Views
Published
In this video, I'm going to teach you how to make a multi-field search form so that you can find records based on multiple criteria such as a partial first name, last name, state, and so on. We'll also see how to search for numeric values, including dates, and yes/no fields.

This video is a followup to one of my most popular YouTube videos on making a multi-field search form. The original was released in 2011 and received over 580,000 views and more than 500 comments and questions over the past 10 years. So in this video, we're going to build the Search Form bigger and better, add some new features, and answer some of the questions people posted about the original.

Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a much more powerful version of this search form without using a query. We will use VBA to dynamically write the SQL statement that feeds data to the form on the fly. We will also resolve the problem of the blank values, and see how to incorporate a sort order into our form.

MEMBERS VIDEO:
https://youtu.be/aumrl1y275E

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/SearchForm2

LINKS:
Original Search Form: https://599cd.com/MultiFieldSearch
Blank Database Template: https://599cd.com/Blank
Query Criteria: https://599cd.com/Criteria
Value From Open Form: https://599cd.com/FormName
Wildcard Search: https://599cd.com/Wildcard
Concatenation: https://599cd.com/Concat
Between: https://599cd.com/Between
Intro to VBA: https://599cd.com/VBA
Search Seminar: https://599cd.com/SearchSeminar
SQL Seminar: https://599cd.com/SQLSeminar
IIF Function: https://599cd.com/IIF
AfterUpdate: https://599cd.com/AfterUpdate
Evil Access Stuff: https://599cd.com/Evil
Double Double Quotes: https://599cd.com/Double

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, search form, requery, dynamic sql, find records, locate specific records, query criteria, search box, search criteria, go to specific record, search form multiple fields, multi field search, filter multiple fields, multiple criteria, multi field search form, advanced search form, multiple keyword search, wildcard, vba, sql, me.requery

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Category
Management
Be the first to comment