Yes. I would also like the cbo to dropdown/open while the user types in the txtSearchForm so they can see the results as they type rather than after the fact.
Advanced Beginner
Windows 7 64bit 
Access 2010 64bit
Yes. I would also like the cbo to dropdown/open while the user types in the txtSearchForm so they can see the results as they type rather than after the fact.
Generally AccessAble
Windows 7 32bit Access 2010 32bit
Quick update: It’s not the most elegant solution I’ve ever seen, but I did come up with something that filters with the wild cards. I still need to finish the coding and get things cleaned up, but I should have something back to you on Monday.
Steve
Generally AccessAble
Windows 7 32bit Access 2010 32bit
OK, here's the solution I came up with. As I mentioned, it's not the most elegant, but it does work. There's a Word doc in the ZIP file as well that explains what I did.
Steve
Advanced Beginner
Windows 7 64bit Access 2010 64bit
Wow, thank you for your hard work and time! Word doc is a nice bonus! I feel lucky!
Geez you even had to use the Timer! Access can sure be clumsy at times. Interesting to know not all languages are as bad as VBA.
Not sure what happened regarding the missing references, as I didn't do anything.
I can't wait to implement this into my live database, but probably won't happen today as I'm getting slammed with emails.
Ken
Advanced Beginner
Windows 7 64bit Access 2010 64bit
Working out pretty good except for one snag we just came across. It doesn't allow searching with spaces.
Generally AccessAble
Windows 7 32bit Access 2010 32bit
Ya got me stumped on this one! At first I thought that maybe you had re-introduced the ignore-space code on your original form, and that was causing the problem, but I'm seeing the described behavior without that code. Taking out the "jump to the end of the string" code in the text box GotFocus event didn't help either.
I think you may have to bite the bullet and choose between a "contains" search that can't handle spaces, and a "starts with" search where spaces are OK. The latter is the default behavior of a Combo Box, so you can replace the text box/list box pair on that form with a single Combo that will do the same job.
Steve
Advanced Beginner
Windows 7 64bit Access 2010 64bit
Thanks for taking another look at this.
If anyone else has a way to tackle the space issue let me know.
Advanced Beginner
Windows 7 64bit Access 2010 64bit
I just discovered another issue. If the first letter to search on is the letter " i ", then the following error occurs:
Run-time error 2110:
Microsoft Access can't move the focus to the control txtHidden
I think this one is Gremlins at play!
Cant see where its wrong - VBA wildcard search.
combobox rowsource
Wildcard Expressions in Search Field
Use combobox to control Subform
Posting Permissions
Reply With Quote