Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: returning proper value from textbox in search form
Hello:
I'm working on a search form that searches on various criteria and display the information in a grid box. For examples the user can search on one or more items to get information on a client. The search works fine except for a small problem.
When the user enters a name i.e. "o'keefe" if returns nothing and if they enter okeefe I get my data displayed, therefore it's too restrictive. I need my data to display if they enter o'keefe, okeefe
or o keefe. Also I'd like it to display all data for names beginning with a particular letter.
the code in my valid event of textbox is:
If not empty(this.value)
str3 = client.surname = '" + this.value + "'"
Endif
Can I incorporate the left() function here to get the results I need? I've tried a few things with it and still don't get the results I need. Any suggestions would be appreciated. Thank you.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement