Results 1 to 1 of 1
  1. #1
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

    Keyword or fragment search

    The database attached here in zip file meep4.zip was deleted from the original thread. It was attached to post#50 originally (2011)
    https://www.accessforums.net/showthr...hlight=keyword

    The database is meepjed.mdb

    You should review that that series of posts to understand the context of the original poster's (meep) problem/issue.
    You will also see how during the course of these posts how the issue evolved and how the database developed.

    In overview the OP had a number of barcoded medical reference texts, with Titles and details.
    The problem/issue was to be able to retrieve records quickly based on Keywords and/or fragments within the Title.



    In the Reserves Database form, you can select an output (Form, Print Preview, PRINT).

    You can enter any number of keywords or fragments ( 1 or more characters) separated by one or more spaces.
    There is an implicit AND between keywords and fragments. That is, records returned will be those with all keywords and fragments
    that were entered in the Search Phrase.

    There is a command button with a magnifying glass image. Click this to invoke the Keyword search.

    The code behind the button will handle any number of terms/fragments as long as they are separated by one or more spaces.
    The search will convert various different quotes found on some keyboards to the single quote/apostrophe (').
    It will open another form (Found Titles) if there are Titles matching the search terms OR it will give a message that no Titles exist with all of those terms.
    You could close the Found Titles form, then click a different button on your form to Preview a Report.

    When looking at returned records in the Found Titles form, you can double click on the ItemBarcode to open another form
    showing the details of the reference record.

    Jpgs of various forms are attached.

    There are 596 records in the database. The Titles contain 1448 distinct keywords.
    Attached Thumbnails Attached Thumbnails ReservesDatabase.jpg   ReservesDatabaseNoSuchRecord.jpg   ReservesDB_RecordsWith_s_AND_omy.jpg   ReservesDB_DetailsOfRecordWithBarcode_47669005.jpg  
    Attached Files Attached Files
    Last edited by orange; 09-03-2016 at 12:46 PM. Reason: assigned proper link

Please reply to this thread with any new information or opinions.

Similar Threads

  1. keyword search
    By Mbakker71 in forum Access
    Replies: 5
    Last Post: 02-05-2014, 06:03 AM
  2. keyword search in a combo box
    By pbouk in forum Forms
    Replies: 9
    Last Post: 05-30-2013, 09:45 PM
  3. A TRUE Keyword Search
    By Meep in forum Queries
    Replies: 72
    Last Post: 05-13-2013, 06:45 PM
  4. Replies: 3
    Last Post: 06-20-2011, 05:36 PM
  5. Making a keyword search
    By timmy in forum Forms
    Replies: 9
    Last Post: 03-14-2011, 02:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums