Repost Need a better search engine

[at51178]

I have a form with a search engine but the search engine that I have is not so robust for my next project does any one know how I can tweak this so that the search results are better.

Basically I want the result to look up any word that matches my criteria.

This is the code that I am using right now.

Me.RecordSource = "SELECT * " & "FROM tblHelp " & "WHERE tblHelp.Result LIKE '*" & Forms!frmIndex!txtSearch & "*';"

 

[Darrylles]

Hi at,

What do you mean by: "how I can tweak this so that the search results are better"?

You will be getting the search results that you have asked for in the SQL statement i.e. all records where RESULT field is LIKE the contents of txtSearch.

You can't GET any better than 100% accurate.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[at51178]

Well I want it to search for every word in the search criteria against what I have in the database

so if I am looking for red crayons and its not it not database but blue crayons is the it will bring back blue crayons


right now if I am searching for something it has to be exactly or close to exactly what I was typing

 

[SuicidED]

Hi look at the post 2 lines below, thread702-673808, that should help.

 

[at51178]

Sorry but that didn't do the trick do you know of any websites that may give me insite to what I am looking to do or do you know if there is another way to rewrite the following code for a form so that the search engine is more robust.



Me.RecordSource = "SELECT * " & "FROM tblHelp " & "WHERE tblHelp.Result LIKE '*" & Forms!frmIndex!txtSearch & "*';"