Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Access Search Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

This seminar will teach you just about everything there is to know about searching and sorting data in Microsoft Access. This seminar is for the intermediate to advanced Access developer. You will...

1. Learn how to perform basic find & replace, filter & sort operations
2. Create parameter queries to prompt users for input
3. Learn how to use form fields as parameters without prompts
4. Perform wildcard searches and learn how to deal with blank or NULL data
5. Search for records using a combo box on a form
6. Understand the difference between embedded macros and VBA code
7. Design a single-field search button to quickly find data in a selected field
8. Learn how to apply filters using VBA commands
9. Design search forms using custom SQL commands and VBA
10. Manipulate your form search results and modify the sort order of records
11. Create a simple search form designed for novice users with hidden advanced options
12. Build a recent customer list to quickly open those clients you work with often
13. Search for data in multiple tables using one quick search form
14. Search for products using ranged criteria (between dates, dollar amounts, etc.)
15. Quickly view summary information on returned result sets (count, max, min, etc.)
16. Design a natural language search that can decide what type of search you want
17. Create a search-as-you-type form that updates results with each keystroke

You can download a free sample database, watch free lessons, and learn more about this seminar here: Microsoft Access Search Seminar

SearchF on multiple tables Upload Images   Link  
Elaine Heltman 
7 months ago
I created a Search form with unbound search fields from 4 different tables and with results appearing in 4 unbound list boxes. Works like a dream. Id like some advice on the proper VBA to add to the Search button On-Click event for a Msgbox to appear when an entry is not found for only the search field containing the search text. In my most recent version, the msgbox runs even when a search result is found and if I search using the other search fields - it's indiscriminate. Ive tried a few variations and searched your website for ideas; here is my most recent attempt: Read More...
Kevin Robertson
7 months ago
Try this:

If Forms!SearchF!LesseeList.ListCount = 0 Then
   MsgBox ("Search entry not found.")
End If
Elaine Heltman
7 months ago
Thanks for the quick response, but it didn't work. The MsgBox still runs if a result is returned.
Add a Reply
Search Seminar 34 Reports Upload Images   Link  
Stephen Southcombe 
8 months ago
As requested I am transferring this question from my post on Facebook -

"Richard, God bless ya, but I am totally not getting Lesson 34 of the Search Seminar.
I have all this vba allowing me to search a large table just about any way anyone could want and view it in a form.....but I can't translate that search method into a report? Read More...
Richard Rost
8 months ago
Hi Stephen. I'm not sure what you don't understand. Explain to me the problem, please. Do you need more help understanding string concatenation?
Stephen Southcombe
8 months ago
Hello Richard;

No, I'm having trouble understanding / programming my reports to show the data I want.

I have a complex search form with more than 30 different combo box fields for which I have vba written to look up data according to the values selected (additionally with tri-state conditions). Everything works great for showing the desired data in a form when I run the vba.

My trouble lies in trying to translate that into a report.

I am able to get a "start date" and an "end date" to work together for a report. But when I go beyond that I start getting parameter query boxes popping up on the screen asking me for values that it should be getting from the search form.

I know you state in the Search Seminar 34 Lesson that reports don't function the same as forms and then you go into creating "Wh2" as a means to work around this but I am not understanding how to code it.

Add a Reply
Combo Box Search not working Upload Images   Link  
Julian Okolonji 
8 months ago
Hi Richard, I have followed the search seminar and I cant get the combo box on customer form to work, does it have anything to do with the version of access (O365)

Many thanks
Adam Schwanz
8 months ago
Combo box search works fine on o365. What error are you getting? Rewatch and check yours.
Richard Rost
8 months ago
Combo boxes haven't changed much in years. Try a new blank database. Also check the Troubleshooter.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

1/28/2022Duplicate Record
1/28/2022ABCD Core Part 7
1/27/2022Work Days
1/27/2022MyNetWorkDays (Free)
1/27/2022Access Developer 35
1/26/2022Yes/No Fields
1/22/2022Next Appointment
1/18/2022Access B2 Upgrade
1/17/2022Access Beginner 2 Links

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access search seminar sort filter sql vba  Page Tag: whatsnew  PermaLink