Is it Possible??? 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.

 

[Warrio]

everything is possible, that what Archimedes said...
you can do it using SQL

the purpose is to select only the data that match your filter.
and the statement would look like :
"SELECT FirstName, FullName FOM Table1
WHERE FirstName LIKE ""*" & TextBox1 & "*" "

Not that if you've typed into TextBox1 : "A"
then the query will show you all firstNames and FullName that have in their
firstName the letter A

if you want only the names that starts with an A then use
"SELECT FirstName, FullName FOM Table1
WHERE FirstName LIKE """ & TextBox1 & "*" "

and if you want an exact maching remove all the "*"

 

[guitarfunk24]

everything is possible, that what Archimedes said...
you can do it using SQL

the purpose is to select only the data that match your filter.
and the statement would look like :
"SELECT FirstName, FullName FOM Table1
WHERE FirstName LIKE ""*" & TextBox1 & "*" "

Not that if you've typed into TextBox1 : "A"
then the query will show you all firstNames and FullName that have in their
firstName the letter A

if you want only the names that starts with an A then use
"SELECT FirstName, FullName FOM Table1
WHERE FirstName LIKE """ & TextBox1 & "*" "

and if you want an exact maching remove all the "*"

How will I do that if I want to make it in a form to search one table
and look for anything that matches the word I type in like say I have
a 2/3" Valve and 1/3" Valve so I type in valve and both show up and
not need to type in 2/3" or 1/3" to see what types I have?

 

[Warrio]

It would take too long to give you a full course ; )
Normally you should have one...
but here a website when you can get started if you're really motivated!!

1. http://www.lebans.com/toc.htm where you can download samples
2. http://www.mvps.org/access/toc.htm

Hope it helps!


<[email protected]> a écrit dans le message de (e-mail address removed)...

everything is possible, that what Archimedes said...
you can do it using SQL

the purpose is to select only the data that match your filter.
and the statement would look like :
"SELECT FirstName, FullName FOM Table1
WHERE FirstName LIKE ""*" & TextBox1 & "*" "

Not that if you've typed into TextBox1 : "A"
then the query will show you all firstNames and FullName that have in
their
firstName the letter A

if you want only the names that starts with an A then use
"SELECT FirstName, FullName FOM Table1
WHERE FirstName LIKE """ & TextBox1 & "*" "

and if you want an exact maching remove all the "*"

How will I do that if I want to make it in a form to search one table
and look for anything that matches the word I type in like say I have
a 2/3" Valve and 1/3" Valve so I type in valve and both show up and
not need to type in 2/3" or 1/3" to see what types I have?

 

[guitarfunk24]

It would take too long to give you a full course ; )
Normally you should have one...
but here a website when you can get started if you're really motivated!!

1.http://www.lebans.com/toc.htm where you can download samples
2.http://www.mvps.org/access/toc.htm

Hope it helps!

<[email protected]> a écrit dans le message de (e-mail address removed)...







How will I do that if I want to make it in a form to search one table
and look for anything that matches the word I type in like say I have
a 2/3" Valve and 1/3" Valve so I type in valve and both show up and
not need to type in 2/3" or 1/3" to see what types I have?

Thanks I will take a look at it.

 

[Hooker DBA [MSFT]]

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

it's quite easy