Querie with Data Entry and Wildcards

  • Thread starter Thread starter Puddlypooh
  • Start date Start date
P

Puddlypooh

I am working on a database and I want to make the search for business names
easier. Some of the business names are long and I want the search to use a
string and a wildcard. In a query you can use [...] to enter specfic data eg
[Enter Town] Tamworth, and all businesses in Tamworth show. So as you can
imagine there will be a number of businesses with Tamworth in the name. So
instead of typing in "Tamworth Regional Council" I want to be able to type in
"Tam" and it automatically finds all businesses starting with Tam. This
database already has nearly 5000 entry with more being entered regularly.

Any help greatly appreciated.
 
I don't care for parameter prompts in queries. Consider using controls on
forms for ALL user interaction.

--
Duane Hookom
Microsoft Access MVP


Clifford Bass said:
Hi,

Use: Like [Enter Town] & "*"

Clifford Bass

Puddlypooh said:
I am working on a database and I want to make the search for business names
easier. Some of the business names are long and I want the search to use a
string and a wildcard. In a query you can use [...] to enter specfic data eg
[Enter Town] Tamworth, and all businesses in Tamworth show. So as you can
imagine there will be a number of businesses with Tamworth in the name. So
instead of typing in "Tamworth Regional Council" I want to be able to type in
"Tam" and it automatically finds all businesses starting with Tam. This
database already has nearly 5000 entry with more being entered regularly.

Any help greatly appreciated.
Click to expand...
Click to expand...
 
I am working on a database and I want to make the search for business names
easier. Some of the business names are long and I want the search to use a
string and a wildcard. In a query you can use [...] to enter specfic data eg
[Enter Town] Tamworth, and all businesses in Tamworth show. So as you can
imagine there will be a number of businesses with Tamworth in the name. So
instead of typing in "Tamworth Regional Council" I want to be able to type in
"Tam" and it automatically finds all businesses starting with Tam. This
database already has nearly 5000 entry with more being entered regularly.

Any help greatly appreciated.
Click to expand...

As criteria on the business name field, write:

Like [Enter Business name] & "*"

You will get all business names that BEGIN with the entered letters.

However, that will not return businesses with "Tam" not at the
beginning, so use:

Like "*" & [Enter Business Name] & "*"

which will return North Tamworth , South Tamworth, etc., if "Tam" is
entered.
 
Hi Duane,

I think parameter prompts have their place. As do specialized
parameter forms or extra fields on existing forms. I make use of both. But
I shudder to think of all of the special forms (hundreds?) I would have to
create and maintain just to do as you suggest.

My $0.02 worth,

Clifford Bass
 
I have used parameter prompts in the past and you might even find a post of
mine suggesting one to a newbie.

I don't recall using any "canned" applications that use parameter prompts.
I don't recall creating many special forms. My apps usually include a single
"report criteria" form otherwise they use the existing forms for criteria.
 
Back
Top