Free Lessons
Fast Tips
Topic Index
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

Back to Access Search Seminar

Search Question Upload Images   Link  
Adam Schwanz 
2 years ago
Hello Rick, I went through most of the classes here but still haven't fixed my problem I asked about I believe back in an expert class. Where Search As You Type won't let you put spaces in, have you had any ideas about how to fix that if it's possible? Otherwise I may just abandon the search as you type to let them put more words in.

Also, I was wondering if it's possible to make access recognize symbols that users are searching with? For instance, in current price, if the user could just type in 10 in the field and see greater than 10 current price? Or is my only option there to make a checkbox or something they click to add it into the SQL statement?

Thank You as always
Richard Rost
2 years ago
I did resolve the "search as you type" problem in the Search Seminar, Lesson 33, which I see you've taken. Is it not working for you?

If you want to work with numeric values, I'd suggest putting a combo box before the search form that has ">", "<", "=", and "<>" as options. Default it to "=". Then you can add this to your search string accordingly.

Not sure if I covered that last one in the seminar, but it's not hard to implement. If you can't figure it out let me know and I can make a TechHelp video about it.
Adam Schwanz
2 years ago
Thanks Rick, I was skimming through that one since it looked similar to the expert class and I missed the couple minutes of discussing the space error, that's fixed now. Thank you!

You do discuss the symbols in a combo box in your seminar, I just wasn't sure if there was a way to let the user type it in and have it work like checking what ASCII value the first character was or something and applying it to the SQL statement then if it was "" or "".

Thank you
Richard Rost
2 years ago
Sure. You can do anything you want. You could give them a text box and let them type in = < > etc. You don't even need to go as far as ASCII values, just do a comparison and see if it's an allowed string.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Search Seminar

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:

5/16/2022Referential Integrity
5/15/2022Invoicing Member Discussion
5/12/2022Number Field Size
5/11/2022Create Word Document
5/11/2022Export to Word
5/10/2022On Click Event Timing
5/9/2022Invalid Use of Null
5/7/2022Event Handler
5/6/2022Database Title & Icon

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