Querying keywords in a subform

G

gavin

Thanks to the people who have helped me so far I now have my basic image
database up and running - and I'm pretty pleased with myself!

I have added a second table for assigning keywords to each image. The table
has three fields - KeywordID (primarykey, autonumber), PictureID (foreignkey
to field in main table) and
Keyword (text field for keyword). I think this should be OK - at least it
seems to work :)

My problem now is how to query the keywords. I would like to be able to
enter either one word and find all the records that have that word in their
list of keywords or more than one word and find all the records that have
ALL those words in their keyword list. Is this possible? If so, I hope it's
not too hard :) I've been pointed in the direction of
http://www.mvps.org/access/forms/frm0007.htm. If this is what is needed can
anyone talk me through it step by step? One last thought - when querying how
would I enter the search words? Is it possible to have a form to enter the
words into boxes (or similar)?


Thanks in advance for any help you can give me.



Gavin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing {PAGE/*MERGEFORMAT} from my microsoft document 5
Columns appearing from nowhere, formatting going weird 0
Format change in merge data - Bold formatting after a comma 0
Change a great number of words in word files, with a macro as short as possible. 5
Filter for years and keywords 6
Get field-value from dropdown-menu value 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Delete all data after a symbol in a field 0

Top