How to make a Partial Search Query or partial search function

[Guest]

Hi all,
I have a Chemical table that contain all chemical. I need to search for their name offten. If there is not this chemical in the table, I will input this chemical. If the chemical already in the table, I will not to input it. However, find function in access just find the exactly name of chemical. If I have a mistake in typing the name of chemical (this happens all the time), the result will be nothing.

I want to make a query that just input partial of the name of chemical then list all of the chemicals that have almost the same name.

Are there any suggestion that would hepl,
Thanks,

 

[Rick B]

To search for a partial entry you would do something like...


Like *hydro*


This would find the string "hydro" anywhere in the field.

Rick B


Hi all,
I have a Chemical table that contain all chemical. I need to search for
their name offten. If there is not this chemical in the table, I will input
this chemical. If the chemical already in the table, I will not to input it.
However, find function in access just find the exactly name of chemical. If
I have a mistake in typing the name of chemical (this happens all the time),
the result will be nothing.

I want to make a query that just input partial of the name of chemical then
list all of the chemicals that have almost the same name.

Are there any suggestion that would hepl,
Thanks,

 

[Guest]

Hi Rick,

How to make this become a parameter query? Just input a part of chemical name this list all the chemicals.
Thanks,

 

[Rick B]

in the parameter put...


Like "*" & [EnterPartialChemicalName] & "*"



Rick B




Hi Rick,

How to make this become a parameter query? Just input a part of chemical
name this list all the chemicals.
Thanks,

 

[Guest]

Hi Rick,
Thank You very much. It works!!!

Now could you help me to display the result in a form.
I make a form (bound form by this query) and a unbound text box for parameter. Now how can I make it work. When I input the parameter then the result will appear in the form (Can it appear like a data sheetview).

Again, I thank you very much.

--
Le Tran

in the parameter put...


Like "*" & [EnterPartialChemicalName] & "*"



Rick B




Hi Rick,

How to make this become a parameter query? Just input a part of chemical
name this list all the chemicals.
Thanks,

--
Le Tran

To search for a partial entry you would do something like...


Like *hydro*


This would find the string "hydro" anywhere in the field.

Rick B


Hi all,
I have a Chemical table that contain all chemical. I need to search for
their name offten. If there is not this chemical in the table, I will input
this chemical. If the chemical already in the table, I will not to input it.
However, find function in access just find the exactly name of chemical. If
I have a mistake in typing the name of chemical (this happens all the time),
the result will be nothing.

I want to make a query that just input partial of the name of chemical then
list all of the chemicals that have almost the same name.

Are there any suggestion that would hepl,
Thanks,