Querie with Data Entry and Wildcards

[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.

 

[Clifford Bass]

Hi,

Use: Like [Enter Town] & "*"

Clifford Bass

 

[Duane Hookom]

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

--
Duane Hookom
Microsoft Access MVP

Hi,

Use: Like [Enter Town] & "*"

Clifford Bass

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.

 

[fredg]

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.

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.

 

[Clifford Bass]

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

 

[Duane Hookom]

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.