A simple question

[Edward]

Hi everybody,
Sorry if my question is so off but im new in Access 2007 for find or find
replace it seems Access only works when we select a specific column when I
change the look in dropdown to the tables name ( I suppose this is a way to
tell access search every column) although the value exist in the table it
says not found. Am i missing something ?

 

[Albert D. Kallal]

Hi everybody,
Sorry if my question is so off but im new in Access 2007 for find or find
replace it seems Access only works when we select a specific column when I
change the look in dropdown to the tables name ( I suppose this is a way
to
tell access search every column) although the value exist in the table it
says not found. Am i missing something ?

Try searching for something else. Perhaps there is a extra space after what
you are looking for?

Also, try using "any part of field" for the search, that way you can type in
less characters and not have to search for an exact match.

So, for the 1st drop down "look in" choose the table name (it will have been
defaulted
to the current collum name), and for the 2nd drop down "match" choose
any part of field.

I just tried the above..and the seaching just worked fine for me.

 

[Edward]

Thanks, I read Access help and your suggestion and it worked. I'm not sure
why should we select "any part of field" because at least going by its name
it suggests that it is used when we are looking for a substring in a text
filed or something that is part of a filed content which refer to an
individual field. As I said I’m new in Access but common sense tells me just
selecting look in ( table name) must give us correct results…? another words
I dont understand the logic behind this extra step of selecting "any part of
field"
Best regards,
Edward

 

[Albert D. Kallal]

I dont understand the logic behind this extra step of selecting "any part

of
field"

Whole field means you are looking for a an exact match.

I might want to find person with the firstName called

Sue

however, I do NOT want to match sues suesans superSuesuper etc.

That setting controls if you looking for a EXACT match (whole field), or a
partial match (any part of field). When you have lots of names or records,
a partial match will RETURN TOO MANY matches.

What happens if you need to look for a field that has ONLY the letter
"e" in it. A partial match would return any word in the table with the
letter "e" anywhere in the text, and that is not what we want. So, you
need control over how the search is going to work else that not going
to be a very usefull search...