Results 1 to 6 of 6
  1. #1
    JrMontgom is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Location
    Vero Beach, FL USA
    Posts
    124

    How to view in a form a Adobe Acrobat PDF document and search the document


    I have a PDF document showing pictures of members and their names, address etc. I want to display this document and I want to search the document using the Ctrl F or search as I am able to do in Adobe Acrobat. Any suggestions?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You can use OLE objects to display certain files that are stored on a hard drive. You can also use attachment fields to store files in the DB. I don't believe you will have the ability to search text within an embedded or linked PDF.

  3. #3
    JrMontgom is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Location
    Vero Beach, FL USA
    Posts
    124
    Quote Originally Posted by JrMontgom View Post
    I have a PDF document showing pictures of members and their names, address etc. I want to display this document and I want to search the document using the Ctrl F or search as I am able to do in Adobe Acrobat. Any suggestions?
    I have been able to use the Word library to create and manipulate a Word document and I have seen others use Excel library to access the Excel spreadsheet within MS Access why can't you do this with Adobe Acrobat PDF file? I can view methods for Acrobat in the Code view of MS Access but I can't seem to access a PDF document. Any help out there or is this a "special case"? Thanksfor all your help

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    OLE will use ActiveX and since Adobe is outside of the Windows family it may not include all of the features you may expect or wish for. Did you try and interact with the PDF using the attachment field or an OLE object? There may be a third party add in that will do the job for you. I do not know. I was just offering a direction to look at.

    I am satisfied with opening PDF files in another window.

  5. #5
    JrMontgom is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Location
    Vero Beach, FL USA
    Posts
    124

    Thumbs up Solved PDF File displayed

    Thanks for your help. I used an Attachment field type and created a form to display the PDF file. I then used, thanks to a great programmer, a function to read the clipboard. SO the user clicks and Opens the attachment and then using Ctrl F to Search and Ctrl C to Copy they put the info on the Clipboard and when returns to the Form Pastes the Clipboard contents, if any, to a text box on the form.

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Cool, glad you were able to find a solution that is beneficial to the user/application.

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

Similar Threads

  1. Need to view linked document in report
    By dagwood in forum Reports
    Replies: 4
    Last Post: 05-09-2013, 07:27 AM
  2. Form to Word or another email able document
    By Rynorem23 in forum Forms
    Replies: 2
    Last Post: 01-28-2013, 04:37 PM
  3. Embed word document into form
    By jgelpi16 in forum Forms
    Replies: 4
    Last Post: 06-26-2012, 11:31 AM
  4. Replies: 3
    Last Post: 05-19-2011, 10:20 AM
  5. Word document INTO Access form
    By jonathonhicks in forum Forms
    Replies: 0
    Last Post: 04-30-2007, 05:59 PM

Tags for this Thread

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