Results 1 to 11 of 11
  1. #1
    mrcunknown is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    12

    Help on a searchform


    Hi all,

    I want to make use of the following searchform, but with lack of my knowledge :-) .......

    Can somebody help me out. I would like that i can easyler find documents and so by filling in a keyword, double click and than a form opens with document description and the path where i can find it on the computer or network.

    searchform.accdb

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Looks like you're trying to use this method but haven't actually specified the criteria:

    http://www.baldyweb.com/wherecondition.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    searchform.accdb
    How about this? Changed the recordsource for the main form, and added the textbox for the docLink. The search form was OK.

    Edit: Paul, the criteria is built into the listbox's rowsource query.

  4. #4
    mrcunknown is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    12
    Thnx! that works great. Is it also possible that tereis a DOCDescription feild?

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by davegri View Post
    Edit: Paul, the criteria is built into the listbox's rowsource query.
    The first form I looked at had a search button, so I was apparently looking at the wrong form.

    Code:
        Dim stDocName As String
        Dim stLinkCriteria As String
    
        stDocName = "frmDOCSearch"
        DoCmd.OpenForm stDocName, , , stLinkCriteria
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Is it also possible that there be a DOCDescription feild?
    No problem:
    searchform-davegri-v02.accdb

  7. #7
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    The first form I looked at had a search button, so I was apparently looking at the wrong form.
    Yes, that criteria is superfluous and can be discarded...

    Code:
    Private Sub cmdSearch_Click()On Error GoTo Err_cmdSearch_Click
    
    
        Dim stDocName As String
        'Dim stLinkCriteria As String
    
    
        stDocName = "frmDOCSearch"
        'DoCmd.OpenForm stDocName, , , stLinkCriteria
        DoCmd.OpenForm stDocName
    
    
    Exit_cmdSearch_Click:
        Exit Sub
    
    
    Err_cmdSearch_Click:
        MsgBox Err.Description
        Resume Exit_cmdSearch_Click
        
    End Sub

  8. #8
    mrcunknown is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    12
    Cool ... thnx for your quick help :-)

  9. #9
    mrcunknown is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    12
    sorry but I have a question about this. Is it possible that instead of the link there is a button. when I click the button that opens the link?

  10. #10
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    searchform-davegri-v03.accdb
    Added a button to follow the hyperlink. I get an error, but that's because I have no access to your onedrive.
    Hope it works for you.

  11. #11
    mrcunknown is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    12
    cool ... thnx so much

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

Similar Threads

  1. Replies: 4
    Last Post: 07-05-2018, 03:16 PM
  2. SearchForm
    By Ray67 in forum Forms
    Replies: 4
    Last Post: 08-20-2014, 09:55 AM
  3. Multi Criteria Searchform
    By cap.zadi in forum Queries
    Replies: 31
    Last Post: 01-20-2012, 01:56 PM
  4. Searchform query opened by macro
    By chessico in forum Forms
    Replies: 1
    Last Post: 08-19-2011, 10:03 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