I have a small (60 mb) Access 2000 base I developed for a state agency that resides on their network. In a separate folder on the same network, there are around 20 gigs worth of scanned invoices in PDF format. The Access base archives the documents (with an individual description and document title) and the user can call up an individual PDF by clicking on the document hyperlink that refers to a PDF in the separate folder on the network. I developed a "keyword" type search mechanism, where the user could look up all of the documents with relevance to, say an individual company for instance. The Access query will then list the number of documents and their corresponding PDF hyperlinks in the form screen, like a list of "hits". MY QUESTION IS, can Access print all of the documents the listed hyperlinks lead to, based upon what the query returns? For, instance a "print all" button, that would print all of the PDF files that the listed hyperlinks refer to . . . Any help would be greatly appreciated, or even direction for research. I have several reference books, and have attempted a shell execute type VB script with no success.
Thanks,
ian@everynobody.com
Thanks,
ian@everynobody.com