How to make keyword search...

[fireballs]

Dear Experts,

How can i make a search button which actually find keyword enter, Let say i have a topic field the data type is memo then this is a praragraph data entry, for example i want to find a word networking then all topics that have networking match will appear. How can i do this...

pls help me..

fireballs

 

[Custom24]

I've not actually done this for multiple keywords, but SQL can do it.
I think what you want to do is to create a new recordset which is filtered based on criteria you specify in an SQL statement.
For example
Select * from tblTable
Where fldField LIKE '*Keyword*'

I suppose if you needed multiple keywords then the where clause would be

Where fldField like '*Keyword*' or fldField like '*OtherWord*'

If you don't know SQL then

http://www.sqlcourse.com/

is excellent

Depending on what you want to do, you may need to clone the existing recordset using the clone method before you apply your filter

Hope this helps
Mark

 

[fireballs]

thanx a lot but i have to visit the

http://www.sqlcourse.com/

first 'coz its true that i need more skill in sql.

thanx anyway mark....