Search Engine????

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

guitarfunk24@yahoo.com - 19 Jun 2007 19:11 GMT

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.

Reply to this Message

Chris2 - 20 Jun 2007 01:12 GMT

> 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
[quoted text clipped - 7 lines]
> 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.

Reply to this Message

dbahooker@hotmail.com - 20 Jun 2007 06:51 GMT

it's not _THAT_ complex

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

On Jun 19, 6:12 pm, "Chris2"
<rainofsteel.NOTVA...@GETRIDOF.luminousrain.com> wrote:

> <guitarfun...@yahoo.com> wrote in message
>
[quoted text clipped - 28 lines]
>
> Chris O.

Reply to this Message