PDF inside Access forms looks small in size by using ActiveX

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mumbaimacro
    New Member
    • Sep 2006
    • 25

    PDF inside Access forms looks small in size by using ActiveX

    hi
    i am using Adobe pdf reader ActiveX in ms-access, I have given in form load()
    Code:
    Private Sub Form_Load()
    
    Dim FILENAME As String
    
    FILENAME = "D:\SAMPLES\Test.pdf"
    
    AcroPDF5.LoadFile FILENAME
    
    End Sub
    when i run the form , i can see the Test.pdf inside the form But it looks very small in size , i can't drag also.No other option .is there on the window..

    help me to get a normal view of the PDF inside access forms


    thanks!
    Last edited by NeoPa; Apr 25 '09, 02:19 PM. Reason: Please use the [CODE] tags provided
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Why can't you change the size of the control in design view. The only other option i can think of is actually opening the Adobe Reader from Access. I know this can be done but i don't know the code.

    Comment

    • PEB
      Recognized Expert Top Contributor
      • Aug 2006
      • 1418

      #3
      See also the properties of your control! Especially Size Mode! There is option Clip Stretch or Zoom! Try the 3!
      :)

      Comment

      • PEB
        Recognized Expert Top Contributor
        • Aug 2006
        • 1418

        #4
        And which references do you use in your visual basic for load the acrobat?

        :)

        Comment

        • mumbaimacro
          New Member
          • Sep 2006
          • 25

          #5
          Originally posted by PEB
          And which references do you use in your visual basic for load the acrobat?

          :)

          hi i have checked the size property for the control,, dont have for the particular pdf control.

          enabled References:

          Adobe Acrobat 7.0 Type library
          Acrobat Access3.0 type library
          Adobe acrobat 7.0 browser control type 1.0

          i can drag the size in desgin time , but when executing the form its still same small size pdf..

          thanks

          Comment

          • coombes
            New Member
            • Oct 2006
            • 1

            #6
            you need to expand the PDf active object under VBA code

            assuming you are using the Acrobat 7 Browser control and have named it AcroPdf1 then the code I use is as follows In my form onload even.

            You can also resize it under code when it is running using VBA
            Code:
                        Me.AcroPDF1.LoadFile ("C:\PMCMS\Dummy.pdf")
                        Me.AcroPDF1.setShowToolbar (False)
                        Me.AcroPDF1.Height = 3800
                        Me.AcroPDF1.Width = 12000
                        Me.AcroPDF1.setView ("FullScreen")
                        Me.AcroPDF1.Visible = True
            you must of course set up the references to the type library and have the activex object dropped on to the form

            Hope that helps
            Last edited by NeoPa; Apr 25 '09, 02:21 PM. Reason: Please use the [CODE] tags provided

            Comment

            • mumbaimacro
              New Member
              • Sep 2006
              • 25

              #7
              thanks buddy...

              its workn.

              Comment

              • dbstiles
                New Member
                • Apr 2007
                • 1

                #8
                I seem to be having difficulty enabling the Adobe Acrobat 7.0 Type library. I can't seem locate that reference in the list. Does anyone know of a reason why this library would not show up besides. Adobe Acrobat 7.0 and the SDK are both installed.

                Thanks for any help you can provide.

                Originally posted by mumbaimacro
                hi i have checked the size property for the control,, dont have for the particular pdf control.

                enabled References:

                Adobe Acrobat 7.0 Type library
                Acrobat Access3.0 type library
                Adobe acrobat 7.0 browser control type 1.0

                i can drag the size in desgin time , but when executing the form its still same small size pdf..

                thanks

                Comment

                Working...