Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PDF to Access (Access 97/SR2)

    Is there a way to take an Adobe 5.0 PDF form and import it into a MS Access 97 database? We were told we could do this provided we had Windows 2000, however, we are currently running Windows 95 on the desktop and it will be 6 months+ before migrating to Windows 2000.

    Any suggestions are welcomed!

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF to Access (Access 97/SR2)

    Set up a dedicated directory for the PDF files and place the PDF files in the directory.
    You will need some files to see this process work..
    You probably want to view the document in a form.

    Create a text field named ImagePath in the appropriate table and save.
    Set an icon's path as the default value.

    Create a form with the field ImagePath.
    Place the following code in the After Update Event in the ImagePath field.

    Private Sub ImagePath_AfterUpdate()
    On Error Resume Next
    Me![ImageFrame].Picture = Me![ImagePath]
    End Sub

    In the form create an Image Frame, named ImageFrame.
    Make the field large as this is where you will be viewing the PDF document.
    In the On Current Event Property of the Form place the following code.

    Private Sub Form_Current()
    On Error Resume Next
    Me![ImageFrame].Picture = Me![ImagePath]
    End Sub

    Place the following code in the On Open event of the form.

    Private Sub Form_Open(Cancel As Integer)
    DoCmd.Maximize
    End Sub

    Enter the path to the appropriate file in the ImagePath field and you will see the PDF file.
    This also work with other graphic types.

    This method stores the graphic file outside the database and is preferred as the DB would grow very large.

    Good luck.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF to Access (Access 97/SR2)

    I have also been wondering how to do this. Does anyone have any additional solutions?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: PDF to Access (Access 97/SR2)

    It's also possible to drop the Acrobat reader activex control (pdf.ocx) on a form and use that to display a PDF.
    Charlotte

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: PDF to Access (Access 97/SR2)

    As noted in previous post, you can insert the Adobe Acrobat Control for Active X on a form. Set the control's "src" property to the full path of the .PDF file (ex: C:PDF_FilesTestForm.pdf). In form view you will be able to enter data in the .PDF form and save file, etc just as you would when working directly in Acrobat.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •