Greetings Everyone,
I have a database with a userform search interface. Is there a way to convert this current code, and adapt it to where it will perform partial word searches? As it stands now, if you try to search for, lets say, the second word of a movie title, it will not bring up that movie in the search results.
Thanks in advance for any advice you can give me.
dr
I have attached a sample for your review...
I'm assuming you are referring sub routine Private Sub cmdSearch_Click()
try this instead of
change to
Please Login or Register to view this content.
this just adds * wildcards to your adv filter searchPlease Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
But that would mess up your Year or Runtime search.
I was thinking something more like
Please Login or Register to view this content.
Last edited by bakerman2; 12-12-2017 at 09:52 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Very true, however, I primarily need it to search for movie titles. I will no doubt use this for other purposes and it is good to know about Bakerman2 fix for future problems that might crop up. Thanks to humdinaling and bakerman2 for all the help and suggestions!!
I've edited the code of my previous post so you can now use it for Year, Runtime, Partial Title, Partial genre, Partial MPAA
Thanks for rep+.
Good pick up baker had my blinkers on
this side on second look
ID is greyed out but if that is meant to be searchable too then you need to add it to list of options
Runtime is a bit weird how its works
IMO - going to be very hard to search anything in this field
better off using range or implying at least time frame
ie at least 50 minutes so auto insert a ">" symbol
but then you issues with format as some have with 1h 20 ...some of 58 min or 129
just not really consistent
The ID field is just a marker. basically a row marker.... It has no use really. I really enjoyed both of your solutions and suggestions. thanks!
Cheers thanks for the rep
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks