A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to make a Partial Search Query or partial search function



 
 
Thread Tools Display Modes
  #1  
Old June 15th, 2004, 08:43 PM
Le Tran
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 08:59 PM
Rick B
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 09:14 PM
Le Tran
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 09:20 PM
Rick B
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 09:43 PM
Le Tran
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.