How to Make a Multi-Term Search Form and Report in MS Access

In this episode, we're going to make a form that has several free-form text controls on it that will narrow our search on a single text file so that we can get records matching several phrases. This is handy for situations where you have a text field with descriptions in it that could be in different order, or using plain language where our search items might be embedded in a sentence. This episode will show you how to use the Like operator in Access while accounting for apostrophes in names like O'Connor, so that you don't get syntax errors.

Related Videos:
How to Make a Search Form with Combo Boxes in MS Access
How to Make a Search Form with Combo ...
How to Make Cascading Combo Boxes in MS Access
How to Make Cascading Combo Boxes in ...
Bound vs. Unbound Forms and Controls in Microsoft Access
Bound vs. Unbound Forms and Controls ...
How to Make a Listbox in MS Access Part 2: Multi-select
How to Make a Listbox in MS Access Pa...
How to Create In and Out Listboxes in Microsoft Access
How to Create In and Out Listboxes in...
How to Make a Multi-Term Search Form and Report in MS Access
You are watching this video now!
How to Use Timers to Run Actions or Code on an Interval in Microsoft Access
How to Use Timers to Run Actions or C...
How to Use Before Update in Microsoft Access
How to Use Before Update in Microsoft...
How to Make Changes to Text in a Textbox in Microsoft Access Using SelStart and SelText
How to Make Changes to Text in a Text...
How to Add Combo Box Rows On-The-Fly in MS Access
How to Add Combo Box Rows On-The-Fly ...
How to Run Code as Your MS Access Form Opens - On Open, On Load, and On Current
How to Run Code as Your MS Access For...
How to Use On Close and On Unload with Microsoft Access Forms
How to Use On Close and On Unload wit...

Join me on Patreon!  
Patreon: mackenziedataengineering

Want the code from this video?
http://mackenziemackenzie.com/downloads

For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
Facebook: mackenziedataanalytics
Twitter: seamacke
Instagram: seamacke
Reddit: seamacke
LinkedIn: psmackenzie

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#msaccess #vba #dataengineering

• #education
• #how_to_make_a_multi_term_search_form_and_report_in_ms_access
• #ms_access_like_query
• #ms_access_open_report_with_filter
• #access_multi_term_search
• #access_search_form
• #vba_where_string
• #ms_access_multi_term_search_form
• #ms_access_docmd_openreport
• #search_form
• #ms_access_search_for_record_by_textbox
• #ms_access_tutorial
• #microsoft_access
• #ms_access
• #vba
• #sean_mackenzie_data_engineering