List of items in Access want to select one item and automatically generate a search of a PDF document for the selected value

Posted on 2014-07-12
Last Modified: 2014-07-12
Not sure this can be done:

I have a table in Access that produces a list of distinct items.  The list is displayed in a Access Form. I want to select an item from the list, push a command button on the Access Form that launches an event that automatically generates a search of a PDF document for the selected value.
Question by:clock1
    LVL 119

    Expert Comment

    by:Rey Obrero
    < I want to select an item from the list>
    what are these items?  post sample values.

    <push a command button on the Access Form>

    you will use the click event of the button to do the search

    private sub button_click()

    'the codes goes here
    ' the selected item from the list is


    'which you can use for the search

    end sub

    * if you are searching for the pdf files, you need to supply the folder where they are

    Author Comment

    List contains:  Red, Yellow, Blue
    I select "Blue"
    Press command button
    Event: launches Adobe Acrobat file (I will specify location) and does Search = Blue

    Does Access work with PDF that way?

    Will a PDF form do what I've explained?
    LVL 84

    Accepted Solution

    So you want to search the PDF DOCUMENT for the user's search terms?

    If so, then you'll have to use 3rd party utilities to do this. You can use the Adobe SDK (, or there are quite a few 3rd party utilities that can do this.

    Author Comment

    Scott, Reading about the Adobe SDK, just as your reply came in.  I agree that's the best route for this one.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    One of the questions I get asked again and again is how to validate a field value in an AcroForm with a custom validation script. Adobe provided a lot of infrastructure to do that with just a simple script. Let’s take a look at how to do that wit…
    PaperPort is a popular document imaging/management product from Nuance Communications ( It is in widespread use by both individuals ( and businesses (http:/…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now