Page 3 of 3 FirstFirst 123
Results 31 to 33 of 33
  1. #31
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100

    Ajax, thanks very much for your code and the explanations. I'll go through it carefully (may take a few days) so I understand what it's doing and then I'll apply the VB. Come back soon. Cheers.

  2. #32
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100
    Hi Ajax, I'm just researching the structure you're written and am having trouble understanding the meaning of:

    fltrStr=fltrStr & "," & rst!AssetNamePK
    rst.movenext

    Thanks.

  3. #33
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    lets say your assetname table has the following


    assetnamePK..assetname
    1...………………..abcde
    2...………………..cdefgh
    3...………………..zyx
    4...…………………defqwe

    and the user has typed in 'def'

    the recordset returns records 2 and 4


    so the code is constructing a string which looks like

    ,2,4

    the initial , is dropped further on in the code

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Keyword or fragment search
    By orange in forum Sample Databases
    Replies: 0
    Last Post: 01-23-2015, 02:47 PM
  2. keyword search
    By Mbakker71 in forum Access
    Replies: 5
    Last Post: 02-05-2014, 06:03 AM
  3. keyword search in a combo box
    By pbouk in forum Forms
    Replies: 9
    Last Post: 05-30-2013, 09:45 PM
  4. Multiple Keyword Search
    By gatsby in forum Access
    Replies: 15
    Last Post: 01-21-2013, 10:53 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