Search issues

[Jgr4ng3]

Hello

Firstly, apologies for creating yet another thread regarding a search form - you'll be happy to know the majority of my setup is already complete!


I have created a search function for an internal knowledgebase ran via Access - at present the criteria parameter for my query is

Like "*" & [Forms]![Navigation Form]![NavigationSubform]![NavigationSubForm]![KnowledgebaseSearch]![SearchKeyword] & "*"

This currently works absolutely fine, however if somebody searched a two word criteria such as 'Access help' for example, it would search for the string 'Access help' whereas I would like the query to search for 'Access "*" help' therefore returning any results that contain the words access or help.


Any advice would be greatly appreciated - my attempts have failed thus far, as has my googling...


Many thanks.

 

[plog]

I would use the Replace function (http://www.techonthenet.com/excel/formulas/replace_vba.php). Essentially for every space in the input string, replace it with:

"*' OR LIKE '*"