Access Search

L

lsmith

I have a database of all our clients and for some reason the find will no
longer find the records. There are several that I know are there, but the
find can't find them. Can anyone help?
 
J

John Vinson

I have a database of all our clients and for some reason the find will no
longer find the records. There are several that I know are there, but the
find can't find them. Can anyone help?
Click to expand...

You'll have to provide some more information.

What is "the find"? A Query? the Search operator in a table datasheet?
What are you actually doing to find the record?

And how is your table structured?

John W. Vinson[MVP]
 
L

lsmith

Please forgive me I am a novice at access. My DataBase is set up to store
demographic information on our clients (name, dob, address...etc). When I
need to check to see if a client is ours...I click on the icon with the
binoculars and type in the last name. I then click "find next". I only have
one working table at this time, (other tables are still under construction),
with about 5800 records. For some reason, the "find next" can't find the
records. It also no longer gives me the pop up message that there are no
more matching records. When I look at my table all the records are there. I
am trying to figure out why the search feature is no longer working. Is it
possible that my table is just too big? or is it a glich in the program?
And is it something I can fix?
 
J

John Vinson

Please forgive me I am a novice at access. My DataBase is set up to store
demographic information on our clients (name, dob, address...etc). When I
need to check to see if a client is ours...I click on the icon with the
binoculars and type in the last name. I then click "find next". I only have
one working table at this time, (other tables are still under construction),
with about 5800 records. For some reason, the "find next" can't find the
records. It also no longer gives me the pop up message that there are no
more matching records. When I look at my table all the records are there. I
am trying to figure out why the search feature is no longer working. Is it
possible that my table is just too big? or is it a glich in the program?
And is it something I can fix?
Click to expand...

Several suggestions:

1. Your database might be corrupted. MAKE A BACKUP (if you don't have
one you need one!!!). Select Tools... Database Utilities... Compact
and Repair Database.

2. Learn about Queries. Table datasheets are VERY limited in their
capabilities. Create a Query based on your Table; select all of the
fields that you want to see; on the Criteria line under Name type

LIKE "*" & [Enter name, or part of a name:] & "*"

Now if you open the Query, you'll get the text between the brackets as
a prompt. If you type "JOHN" you'll get anybody with the string JOHN
anywhere in the name field - John Smith, Tim Johnston, etc. Use

= [Enter name:]

if you want to see just the exact name as typed (note that
misspellings will NOT be corrected, computers are too stupid to
realize that "johson" might be a typo for "johnson").

3. Select Tools... Options... Edit/Find and make sure that you have
the desired behavior selected in the left-hand box: "Fast Search" will
search for the name exactly as typed; "General Search" will search for
the typed string anywhere within the name; and "Start of Field Search"
will find a name if you type the first few letters of the name. This
might have changed from your original setting.


John W. Vinson[MVP]
 
M

mutlu

be careful when you open find menu. There are three options.
1. look
2. match
3. search direction.
You must do your search applying these criterias. Especially, you should
choose the database which you use from the look option.

John Vinson said:
Please forgive me I am a novice at access. My DataBase is set up to store
demographic information on our clients (name, dob, address...etc). When I
need to check to see if a client is ours...I click on the icon with the
binoculars and type in the last name. I then click "find next". I only have
one working table at this time, (other tables are still under construction),
with about 5800 records. For some reason, the "find next" can't find the
records. It also no longer gives me the pop up message that there are no
more matching records. When I look at my table all the records are there. I
am trying to figure out why the search feature is no longer working. Is it
possible that my table is just too big? or is it a glich in the program?
And is it something I can fix?
Click to expand...

Several suggestions:

1. Your database might be corrupted. MAKE A BACKUP (if you don't have
one you need one!!!). Select Tools... Database Utilities... Compact
and Repair Database.

2. Learn about Queries. Table datasheets are VERY limited in their
capabilities. Create a Query based on your Table; select all of the
fields that you want to see; on the Criteria line under Name type

LIKE "*" & [Enter name, or part of a name:] & "*"

Now if you open the Query, you'll get the text between the brackets as
a prompt. If you type "JOHN" you'll get anybody with the string JOHN
anywhere in the name field - John Smith, Tim Johnston, etc. Use

= [Enter name:]

if you want to see just the exact name as typed (note that
misspellings will NOT be corrected, computers are too stupid to
realize that "johson" might be a typo for "johnson").

3. Select Tools... Options... Edit/Find and make sure that you have
the desired behavior selected in the left-hand box: "Fast Search" will
search for the name exactly as typed; "General Search" will search for
the typed string anywhere within the name; and "Start of Field Search"
will find a name if you type the first few letters of the name. This
might have changed from your original setting.


John W. Vinson[MVP]
Click to expand...
 
Top