DB search any fields?

[Mark M]

Not sure exactly what I want here but I will describe it as best I can

Ive got a product list of approx 100,000 items all with unique codes and descriptions. What I want to do is be able to search any part of the code or description.

IE, on the following product

RF1814BX /C/B/G* Reference 18 x 14 Bass Drum w/o BB3

May need to search for :

a) RF18
b) 18 x 14
c) Bass drum
etc

So for b) if I typed in 18 x 14 it would bring up all the products that had 18 x 14 in the description

What program can do it, if any? Access? Excel?

Thanks for any help

Mark

 

[div0]

Access can certainly do it, and Excel should be able to do it as well, as far as I'm aware.

I've certainly made a similar search query in an Access database before.

Would the 'Find' function, built into Excel not do? Why try to write something yourself if what's already there could do the job?!

 

[Mark M]

It might do, but the price list spans multiple tabs? Is there a way to change the advanced iptions on the seach function to default to within "workbook" and not just "sheet"?

Thanks

 

[div0]

Yes.

In the 'Find' box in Excel, click 'Options' and then the drop down for 'Within' change from 'Sheet' to 'Workbook'

 

[Mark M]

You will have to change that everytime though wont you? Im looking for the quickest option if someone is on the phone or something we can find it ASAP.

 

[div0]

You will have to change that everytime though wont you? Im looking for the quickest option if someone is on the phone or something we can find it ASAP.

Ctrl+F
Options
<change to> Workbook
<type phrase>

Takes about 1-2s for me

I'll try to find a way to make it quicker though!