query for words

[gippsy]

Hello
In a form I have an unbound textbox to search for a word stored in a table. The sql is: Like[Forms]![FSearch].[qPK] & "*". This sql statement works well and return all records from the table with the field related with qPK.
How can I search in another unbound textbox for more than one word? Could be possible that the searched words can be underlined in the query returned?
Many thanks in advance.

 

[jdraw]

... Like [Forms]![FSearch].[qPK] & "*"

you could try something like this (conceptually)

where somefield Like [Forms]![FSearch].[qPK] & "*" OR
someOtherField Like [Forms]![FSearch].[otherTextBox] & "*" OR
someOtherField Like [Forms]![FSearch].[AnotherTextBox] & "*"


Post a specific requirement showing the code involved if you want more info.

 

[gippsy]

jdraw.
Many thanks.
Your code works well, however, Iam looking a different option. I think I explained my idea in the wrong way. At the moment the sql you sended me and one and that I am using only allow me enter one word per textbox.
I hope the next lines will clear what I need.
I need to enter more than one word keywords in an unbound texbox. I woul like to know how to use the criteria AND and OR to understant their correct use
In my relational database the table tblKeyWrd (KwID,KwNam) storage all the KeyWords data.
Yours suggs are welcome

 

[jdraw]

I answered a post on keywords, and provided a sample databases (mdb) in post #22 and others at
http://www.accessforums.net/queries/true-keyword-search-19909/index2.html

See the last databases post#50 and 54
You may get some ideas from it. Take a look and if you have more questions, please post back.

 

[gippsy]

With your application #22 now I understan how to program the sql instruction in the query and works well. Many thanks.
Your application is new to me and I would really appreciate if you explain the above.
Why there is no relationship between the tables in the Relation Object? I always use relations
What is the advantage using tblkwords twice in the query? This is the first time i see it
I can not see the codes of the reserves database and Search Database buttons
What the table noise does?
What the Module does? I woul like to use in my databse but i dont understan the code
Could you send me some references based of your application to learn by myself
I apólogyze if my writting is no clear. English is not my mother tongue.
Thank you very much indeed

 

[jdraw]

Can we work with the meep1.zip in post #26-- it has some adjustments beyond the earlier versions.
I haven't looked at it for a long time (about a year) so it may take a few minutes.
I have attached answers to your questions.