Results 1 to 6 of 6
  1. #1
    Mbakker71 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Posts
    20

    keyword search

    Hello,

    i would like something to search on keywords. but i've no idea how.



    the thing is i can use a like function but i want something that when a user create a record he can add keyword to the record like "bakoven, lelystad, reperatie, tekening"

    and when a user has to find a record he typt into a textfield "lelystad bakoven" the record shows

    hoe can i do that?

    Martijn

    sorry for my bad english

  2. #2
    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
    Look for the dialog with meep inthis set of posts --specifically the meep4.mdb database.
    He had an interesting problem and it took a while to get all the facts and to clean up some of the data.


    Here's the link that has a lot of interaction and lead up to a working example/solution.





  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe you can add another column to your table and name the field MetaSearch or something. You can assign the data type Text or Memo to it. In a form, bind a textbox control to the field and adjust the "Enter Key Behavior" property to = "New Line In Field".

    Now you have a single place to search for keywords that are added by the user.

  4. #4
    Mbakker71 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Posts
    20
    nope i did not find the answer

    i search for something like this:
    dim keyword as string
    dim str1 as variant
    dim search as string
    dim teller as integer

    keyword = me.txtkeyword.value
    Str1 = Split(keyword, ",")
    Dim int1 As Integer
    int1 = UBound(Str1) - LBound(Str1)

    for teller = 0 to int1
    search = search & " AND" & " " & "LIKE" & " " & "*" & " " & str1(teller) & " " & "*"

    me.list44.column(5) = search

    but it is not working

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What happens when you run the code? Is this a Sub or a Function? How is it executed? Why the AND operator? Nothing shows populating search variable for concatenation.

    Can't populate a listbox column like that. Why are you trying to?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    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
    mbakker71,

    Readers do not understand WHAT you are trying to do. Please describe WHAT you are trying to do in plain terms -not Access objects.

    Tell us about your Search requirement. We can not help you until we understand.your requirement.

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

Similar Threads

  1. keyword search in a combo box
    By pbouk in forum Forms
    Replies: 9
    Last Post: 05-30-2013, 09:45 PM
  2. A TRUE Keyword Search
    By Meep in forum Queries
    Replies: 72
    Last Post: 05-13-2013, 06:45 PM
  3. Multiple Keyword Search
    By gatsby in forum Access
    Replies: 15
    Last Post: 01-21-2013, 10:53 PM
  4. Keyword search with Access 2010 FE
    By Brian62 in forum SQL Server
    Replies: 1
    Last Post: 06-15-2012, 06:06 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