Database

[Tim]

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

 

[Norman Jones]

Hi Tim,

Look at AutoFilter.

See Debra Dalgleish's autofilter notes at:

http://www.contextures.com/xlautofilter01.html

 

[Ron de Bruin]

Or this Add-in
http://www.rondebruin.nl/easyfilter.htm

 

[Tim]

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" <[email protected]> wrote

in message news:[email protected]...

 

[Ron de Bruin]

Hi Tim

You can Filter with the Contains option
Autofilter>Custum
or the Begins-Contains-Ends tab in EasyFilter

 

[Tim]

Great! The Easy Filter works well

-----Original Message-----
Hi Tim

You can Filter with the Contains option
Autofilter>Custum
or the Begins-Contains-Ends tab in EasyFilter

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tim" <[email protected]> wrote in

message news:[email protected]...