Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / September 2003

Tip: Looking for answers? Try searching our database.

Search Engine

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vegard H. Villmones - 06 Sep 2003 23:18 GMT
Hi

I need a search engine to put in one of my forms and it is supposed search
an access table (containing song lyrics), and searches it based on keywords
(the standard search engine type like in windows). Somebody must have made
something like this (and made it available for free download) or what?

Vegard
Timbuck2 - 07 Sep 2003 16:45 GMT
Use replace to replace all non alpha chars in the lyric
with nothing
replace double and triple spaces with one space
use split to split on spaces
With each word insert into IndexTable the word
on fail who cares the word is only needed once.
in LyricsToWords table insert WordID and LyricID

Many lyrics to many Words through LyricsToWords

Searches will be much faster on Words you can provide list
of lyrics containing words.

>-----Original Message-----
>Hi
[quoted text clipped - 7 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.