Search Engine????

[guitarfunk24]

Is it possible to make a search engine form on access that searches
for things that match what you typed into it like if you were for
example to use google and type valve and anything that says valve
comes up.

I was just wondering if it is possible and if it is can someone tell
me how to get started on making it because my database has a lot of
descriptions and its hard to search just by part numbers but the
descriptions are pretty long so if I could type in valve or tank and
anything with tank came up that would be awesome. Its just a thought
thank you to anyone that could possible help.

 

[Chris2]

Is it possible to make a search engine form on access that searches
for things that match what you typed into it like if you were for
example to use google and type valve and anything that says valve
comes up.

I was just wondering if it is possible and if it is can someone tell
me how to get started on making it because my database has a lot of
descriptions and its hard to search just by part numbers but the
descriptions are pretty long so if I could type in valve or tank and
anything with tank came up that would be awesome. Its just a thought
thank you to anyone that could possible help.

guitarfun24,

SELECT YT1.<your column>
FROM YourTable AS YT1
WHERE YT1.<your column>
LIKE "*" & Forms!YourForm!txtYourTextBox & "*"

That's the basic search.

To get a search like Google's requires considerably more complexity.
Considerably more.

Sincerely,

Chris O.

 

[dbahooker]

it's not _THAT_ complex

you just should be using Access Data Projects and MS FullText Search