| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database
Hello All,
I have a work book that contains a flat database (table). My user would like to type a keyword(s) that are contained in a particular field and then return a list of records that contain the keyword(s). I would like to do this using userforms? maybe a list box to show the results. I need help with the code that will search the field and return the information. I am open to all suggestions. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Database
Hi Tim,
Look at AutoFilter. See Debra Dalgleish's autofilter notes at: http://www.contextures.com/xlautofilter01.html --- Regards, Norman "Tim" wrote in message ... Hello All, I have a work book that contains a flat database (table). My user would like to type a keyword(s) that are contained in a particular field and then return a list of records that contain the keyword(s). I would like to do this using userforms? maybe a list box to show the results. I need help with the code that will search the field and return the information. I am open to all suggestions. Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Database
Or this Add-in
http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Tim, Look at AutoFilter. See Debra Dalgleish's autofilter notes at: http://www.contextures.com/xlautofilter01.html --- Regards, Norman "Tim" wrote in message ... Hello All, I have a work book that contains a flat database (table). My user would like to type a keyword(s) that are contained in a particular field and then return a list of records that contain the keyword(s). I would like to do this using userforms? maybe a list box to show the results. I need help with the code that will search the field and return the information. I am open to all suggestions. Thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Database
I think the proble with using a filter is that I need to
search a single word in a sentence. Every line or string of text is unique. Ex: "Shot of girl holding lolipop against a white background." The user may be looking for one or a few of the words in the description above. Thanks again -----Original Message----- Or this Add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Tim, Look at AutoFilter. See Debra Dalgleish's autofilter notes at: http://www.contextures.com/xlautofilter01.html --- Regards, Norman "Tim" wrote in message ... Hello All, I have a work book that contains a flat database (table). My user would like to type a keyword(s) that are contained in a particular field and then return a list of records that contain the keyword(s). I would like to do this using userforms? maybe a list box to show the results. I need help with the code that will search the field and return the information. I am open to all suggestions. Thanks in advance . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Database
Hi Tim
You can Filter with the Contains option AutofilterCustum or the Begins-Contains-Ends tab in EasyFilter -- Regards Ron de Bruin http://www.rondebruin.nl "Tim" wrote in message ... I think the proble with using a filter is that I need to search a single word in a sentence. Every line or string of text is unique. Ex: "Shot of girl holding lolipop against a white background." The user may be looking for one or a few of the words in the description above. Thanks again -----Original Message----- Or this Add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Tim, Look at AutoFilter. See Debra Dalgleish's autofilter notes at: http://www.contextures.com/xlautofilter01.html --- Regards, Norman "Tim" wrote in message ... Hello All, I have a work book that contains a flat database (table). My user would like to type a keyword(s) that are contained in a particular field and then return a list of records that contain the keyword(s). I would like to do this using userforms? maybe a list box to show the results. I need help with the code that will search the field and return the information. I am open to all suggestions. Thanks in advance . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Database
Great! The Easy Filter works well
-----Original Message----- Hi Tim You can Filter with the Contains option AutofilterCustum or the Begins-Contains-Ends tab in EasyFilter -- Regards Ron de Bruin http://www.rondebruin.nl "Tim" wrote in message ... I think the proble with using a filter is that I need to search a single word in a sentence. Every line or string of text is unique. Ex: "Shot of girl holding lolipop against a white background." The user may be looking for one or a few of the words in the description above. Thanks again -----Original Message----- Or this Add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Tim, Look at AutoFilter. See Debra Dalgleish's autofilter notes at: http://www.contextures.com/xlautofilter01.html --- Regards, Norman "Tim" wrote in message ... Hello All, I have a work book that contains a flat database (table). My user would like to type a keyword(s) that are contained in a particular field and then return a list of records that contain the keyword(s). I would like to do this using userforms? maybe a list box to show the results. I need help with the code that will search the field and return the information. I am open to all suggestions. Thanks in advance . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
| Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Linear Mode
