[Webinar] Learn how to a build a cloud-first strategyRegister Now


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
Medium Priority
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
  • 2
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40192368
< 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

ID: 40192382
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40192395
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 (http://www.adobe.com/devnet/acrobat.html), or there are quite a few 3rd party utilities that can do this.

Author Comment

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

864 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