|
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 |
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 |
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 |
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 . |
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 . |
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 . . |
| All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com