Access Help

  • Thread starter Thread starter amy.smith4 \(removethis\)
  • Start date Start date
A

amy.smith4 \(removethis\)

I am building a database and want to be able to look up
names in a name field. The names, however, are not all
typical names and the spelling is difficult for many of
them. How can I create a user prompt in a query so the
user only needs to enter the first 3 letters of a name and
have Access return results of all names begining with
those 3 letters?
 
I am building a database and want to be able to look up
names in a name field. The names, however, are not all
typical names and the spelling is difficult for many of
them. How can I create a user prompt in a query so the
user only needs to enter the first 3 letters of a name and
have Access return results of all names begining with
those 3 letters?
Click to expand...

A query with a criterion

LIKE [Enter part of name:] & "*"

will find SMITH (or SMITHSON, or SMILEY, or SMINTHEUS) if you enter
SMI at the prompt.

You might want to consider using a Combo Box based on the names table
- if you have fewer than 65536 names, you'll be able to see the names
as they exist in the table, and the Autocomplete feature will jump to
the first name starting with S when you type S, to the first name
starting with SM when you keep typing with a M and so on.
 
-----Original Message-----
I am building a database and want to be able to look up
names in a name field. The names, however, are not all
typical names and the spelling is difficult for many of
them. How can I create a user prompt in a query so the
user only needs to enter the first 3 letters of a name and
have Access return results of all names begining with
those 3 letters?
Click to expand...

A query with a criterion

LIKE [Enter part of name:] & "*"

will find SMITH (or SMITHSON, or SMILEY, or SMINTHEUS) if you enter
SMI at the prompt.

You might want to consider using a Combo Box based on the names table
- if you have fewer than 65536 names, you'll be able to see the names
as they exist in the table, and the Autocomplete feature will jump to
the first name starting with S when you type S, to the first name
starting with SM when you keep typing with a M and so on.


.
Very Helpful! Thanks so much. I'm sure you'll see me
Click to expand...
here again as I work my way through this project.

ASmith
 
Back
Top