If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to make a Partial Search Query or partial search function
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, -- Le Tran |
#2
|
|||
|
|||
How to make a Partial Search Query or partial search function
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 "Le Tran" wrote in message ... 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, -- Le Tran |
#3
|
|||
|
|||
How to make a Partial Search Query or partial search function
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" wrote: 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 "Le Tran" wrote in message ... 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, -- Le Tran |
#4
|
|||
|
|||
How to make a Partial Search Query or partial search function
in the parameter put...
Like "*" & [EnterPartialChemicalName] & "*" Rick B "Le Tran" wrote in message ... 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" wrote: 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 "Le Tran" wrote in message ... 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, -- Le Tran |
#5
|
|||
|
|||
How to make a Partial Search Query or partial search function
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" wrote: in the parameter put... Like "*" & [EnterPartialChemicalName] & "*" Rick B "Le Tran" wrote in message ... 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" wrote: 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 "Le Tran" wrote in message ... 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, -- Le Tran |
Thread Tools | |
Display Modes | |
|
|