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?
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 "".
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.