Access is NOT case-sensitive so you can't use the standard comparison
operators to search.
If you are looking for a word (or string) anywhere in the Description field
varWhere =
varWhere & "[Description] LIKE ""*" & Me.txtDescription & "*"" AND "
If you really need to do a case-sensitive search for a word anywhere in the
string you are going to have to use some VBA. Simplest ...
Thread: Uppercase and * in search query  |
|||||||||||||
|
Started 3 months, 1 week ago by Wind54Surfer
Hi all,
I am using the following:
If Me.txtDescription "" Then
varWhere = varWhere & "[Description] LIKE """ & Me.txtDescription &
"*"" AND "
to search but have two problems:
1-doesn't work with uppercase words
2-doesn't work unless using "*", if word is in middle of sentence
I adapted the code from a sample found in the web, don't know how to make
changes.
...
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
John Spencer replied 3 months, 1 week ago
Size: 1,906 bytes
Customize: 
Dale Fye replied 3 months, 1 week ago
When you say "doesn't work with uppercase words" I assume you mean that if
you are looking for a word that is in all uppercase, it is returning records
where the word is in lower or mixed case, and not just those where the word
appears in all caps. Is that correct? Unfortunately, Access searches are
not case sensitive, so you are going to get records in your search results
which ...
Size: 3,073 bytes
Customize:
Dale Fye replied 3 months, 1 week ago
BTW, depending on the formatting of the string you are going to search, you
might want to consider removing all of the punctionation marks in the string
being searched and replacing them with spaces. If the word you are searching
for is wrapped by a punctuation mark, it will not pass a binary comparison.
I would add lines similar to the following for all the major punctuation.
...
Size: 1,511 bytes
Customize:
Dale Fye replied 3 months, 1 week ago
Learn something new every day. Has the compare parameter been around
forever, or was it added in 2007. Turns out I've been doing it the hard way
all this time.
----
HTH
Dale
"John Spencer" wrote:
Access is NOT case-sensitive so you can't use the standard comparison
operators to search.
If you are looking for a word (or string) anywhere in the Description field...
Size: 2,300 bytes
Customize:
John Spencer replied 3 months, 1 week ago
As far as I know it has been around since at least Access 97. And Probably
before that.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Dale Fye wrote:
Learn something new every day. Has the compare parameter been around
forever, or was it added in 2007. Turns out I've been doing it the hard way
all this time....
Size: 614 bytes
Customize:
|
Top contributing authorsRelated threads on "Microsoft Office (Excel, Word) forum - OfficeFrustration":Related threads on other sites: |
||||||||||||
Thread profile page for "Uppercase and * in search query" on http://www.officefrustration.com.
This report page is a snippet summary view from a single thread "Uppercase and * in search query", located on the Message Board at http://www.officefrustration.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.