How to make a Partial Search Query or partial search function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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,
 
Hi Rick,

How to make this become a parameter query? Just input a part of chemical name this list all the chemicals.
Thanks,
 
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,
 
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


Rick B said:
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


Rick B said:
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,
Click to expand...
Click to expand...
 
Back
Top