Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Microsoft Access Developer 8
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   4 years ago

Back to Microsoft Access Developer 8

Spaces in Search As You Type Upload Images   Link  
Adam Schwanz 
2 years ago
Hello Richard, I have this working I believe with a macro to open the selected customer as well, however I'm unable to add spaces into the text field. I may be missing the obvious but how can I add spaces so I can do like Fort Myers, Fort Lauderdale etc without just searching the last word?
Richard Rost
2 years ago
Yeah, that's a tricky one. I'll have to think about it. The way I have the code written (if memory serves, it has been 2 years since I recorded that) every time you press a key the string gets "trimmed" so the trailing space would be removed. All I can think of is you'd need to keep a second hidden text box or memory variable with the actual value you type in that doesn't get trimmed.
Todd Auer
2 years ago
I was able to accomplish the spaces by:
1.Make list box. Go to properties, select row source "...", Expr:1 [field 1] & [field 2]
2.Make a SearchBox. Go to properties and set the On Change with Code builder type DoCmd.Requery "List Box"
3.Like "*"& [Forms]![Form Name]![SearchBox].[Text] &"*"   The .Text will select the text inside of the searchbox

I am also wondering how to make this happen with VBA, can't wait for the update. Thanks!
Richard Rost
2 years ago
OK. Maybe I'll put something together and add it to Developer 17. Working on that now.
Richard Rost
2 years ago
OK, I was looking this over and it turns out that I did cover this in the Access Search Seminar. Now, if you don't want to spend $200 on the seminar, I have posted just lesson 33 which solves the "trailing space" problem to my YouTube Channel for GOLD Members and up. Cost of Gold membership right now is only $9.99. You'll get access to that video plus a whole bunch of other stuff including my TechHelp Extended Cut videos. In the future, when issues like this arise - questions about things I've covered before from Seminars - I'll post them like this. I don't really have an easy way to list videos separately HERE on my web site, and it wouldn't be fair to people who did buy the Seminar to waste their time making them watch it in Developer 17, so this solution works for everyone. Enjoy!

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

Back to Microsoft Access Developer 8 Comments

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/27/2022Add Anything
5/26/2022List Items Edit Form
5/25/2022Column Colors
5/24/2022Multi-Table Forms
5/21/2022Access Developer 39
5/21/2022Access Developer 39 Lessons
5/21/2022Access Developer 39
5/21/2022Select Items in Related Table
5/21/2022Clear List Box

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