searching Data Access Page text field

  • Thread starter Thread starter Andres Archila
  • Start date Start date
A

Andres Archila

I have generated a Data Access Page (DAP) with 6 fields,on
of which is a memo field that I would like to search for
any part of a word contained in that field. For example,
the memo field contains descriptions of over 68 courses,
and i want to search for those instances of "algebra". I
want to view those DAP records that have the word algebra
in that memo field course description. I have tried to
create a recorset and then do a:
rs.Find "[memofieldname] ='" & txtSearch.value & "'", 0,1,1

This will work only if the memo text is matched, word for
word, but i need to view those records with the
*searchword* (ie, "algebra", "world war II", "vulcanism",
etc). I have tried to follow the models posted in KB
articles 271728 and 247823; "how to find a record in any
field on a DAP", and "how to find a record from a drop
down list in a DAP", respectively, but have gotten stuck.

I essentially need the same functionality as when in
regular access forms you select a field and do a find for
a key word and search for a match in any part of field.

Any help, suggestions, ideas would be greatly appreciated.
 
rs.Find "[memofieldname] ='" & txtSearch.value & "'", 0,1,1
Click to expand...

You want the search string to look like this:

Instr([memofieldname], "Text To Find") > 0)

so with the quotes and the text insertion, you get something like

strWhere = "INSTR([MemoFieldName], """ & txtSearch.Value & """) > 0"

MsgBox strWhere,, "Check this out"

rs.Find strSQL


Hope that helps


Tim F
 
Back
Top