Bibliography key words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to develop VBA code (for use in MS Access) to enable user to locate
records using 1 or more key words. Each record will have (say) 10 key words.

My questions are:

How should I store the key words - each in separate field or in memo field

How do I set up the search?

How do I present results of search - ie a list of records. Some records may
match 1 of the users key words, others may match manyu or all.

Assistance would be much appreciated.
 
hi Peter,
make a separate text field, make index on it
then, for example you can build a form with textbox to enter search, button
and listbox
when user enter a word into textbox and press button - you build a query for
a listbox, like:

strSQL="Select BookTitle, Author from Books where Keywords like '*" &
me.txtSearch & "*'"

(there is a single quote before and after *)

and then pass this string to list's recordsource

something like this

HTH
 
Back
Top