Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Like vs exact match
Rolf Widmer 
     
2 years ago
I have a form with a Search-As-You-Type textbox with using "Like" command in a query. It works very well without any problems. However if I search for "tea" for example, there are also search results such as "steak", "steam", "team" etc. Is there any possibility to switch between a wildcard search and an exact search or to refine the search?
Thanks in anticipation.
Alex Hedley  @Reply  
           
2 years ago
You could have a radio button to swap between then just have different WHERE clauses
Kevin Yip  @Reply  
     
2 years ago
An exact match in Access is one that matches the entire content of the field, i.e. it contains only the word "tea."  But I don't think that is what you intend.  Your intention (I'm guessing) is to match "tea" whenever the word "tea" alone is found somewhere in the field.  E.g.:

My cup of tea
Tea and Sympathy
Boston Tea Party
Coffee or tea?
"Tea"

This is *considerably* more difficult to code.  You have to break down the words individually and find "tea" among them.  Individual words aren't always separated by spaces, as the examples above show.  Words may be preceded with and/or trailed with punctuation marks, preceded with a space or not, trailed with a space or not, etc.  There are tons of conditions to test whether the word "tea" itself (or any word) exist in the field.

Rolf Widmer OP  @Reply  
     
2 years ago
Hi Alex, Hi Kevin,
Thank you very much for your fast replies. You understood perfectly what I mean!
I will try to follow these two ideas.
Have a nice day
Rolf
Rolf Widmer OP  @Reply  
     
2 years ago
I wonder, whether I can find something about in the Search Seminar before I pay for it?
Adam Schwanz  @Reply  
           
2 years ago
The search seminar does not cover the advanced logic that Kevin is talking about, I don't believe it covers radio buttons either. But it covers everything else you would need. Then you just need to add one more if/then to it to determine which radio button is selected to determine which where clause to use.
Rolf Widmer OP  @Reply  
     
2 years ago
Thanks a lot Adam!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 12:36:20 AM. PLT: 0s