pdf displaying

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • T
    #1

    pdf displaying

    Using 97, I have a db and I also have with many scanned pdf's all
    contained in one folder.

    Within form view I would like a user to be able to click a browse
    button and select a pdf file and have if open from and display the pdf.
    If the image is a jpg, gif or bmp this isn't a problem, but it seems
    with pdf there is a problem.

    Any idea's on how to accomplish this?

    Tags: None
    • salad
      #2
      Re: pdf displaying

      T wrote:
      Using 97, I have a db and I also have with many scanned pdf's all
      contained in one folder.
      >
      Within form view I would like a user to be able to click a browse
      button and select a pdf file and have if open from and display the pdf.
      If the image is a jpg, gif or bmp this isn't a problem, but it seems
      with pdf there is a problem.
      >
      Any idea's on how to accomplish this?
      >
      Take a look at http://www.mvps.org/access/api/api0018.htm.

      I'll assume, that if you were to click the pdf file from Explorer, it
      will open correctly.

        Comment

        • T
          #3
          Re: pdf displaying


          salad wrote:
          T wrote:
          >
          Using 97, I have a db and I also have with many scanned pdf's all
          contained in one folder.

          Within form view I would like a user to be able to click a browse
          button and select a pdf file and have if open from and display the pdf.
          If the image is a jpg, gif or bmp this isn't a problem, but it seems
          with pdf there is a problem.

          Any idea's on how to accomplish this?
          Take a look at http://www.mvps.org/access/api/api0018.htm.
          >
          I'll assume, that if you were to click the pdf file from Explorer, it
          will open correctly.

            Comment

            • T
              #4
              Re: pdf displaying


              salad wrote:
              T wrote:
              >
              Using 97, I have a db and I also have with many scanned pdf's all
              contained in one folder.

              Within form view I would like a user to be able to click a browse
              button and select a pdf file and have if open from and display the pdf.
              If the image is a jpg, gif or bmp this isn't a problem, but it seems
              with pdf there is a problem.

              Any idea's on how to accomplish this?
              Take a look at http://www.mvps.org/access/api/api0018.htm.
              >
              I'll assume, that if you were to click the pdf file from Explorer, it
              will open correctly.

                Comment

                • T
                  #5
                  Re: pdf displaying


                  T wrote:
                  salad wrote:
                  T wrote:
                  Using 97, I have a db and I also have with many scanned pdf's all
                  contained in one folder.
                  >
                  Within form view I would like a user to be able to click a browse
                  button and select a pdf file and have if open from and display the pdf.
                  If the image is a jpg, gif or bmp this isn't a problem, but it seems
                  with pdf there is a problem.
                  >
                  Any idea's on how to accomplish this?
                  >
                  Take a look at http://www.mvps.org/access/api/api0018.htm.

                  I'll assume, that if you were to click the pdf file from Explorer, it
                  will open correctly.
                  Not using explorer --form view of access.

                    Comment

                    • Rick Brandt
                      #6
                      Re: pdf displaying

                      T wrote:
                      T wrote:
                      salad wrote:
                      T wrote:
                      >
                      Using 97, I have a db and I also have with many scanned pdf's
                      all contained in one folder.

                      Within form view I would like a user to be able to click a
                      browse button and select a pdf file and have if open from and
                      display the pdf. If the image is a jpg, gif or bmp this isn't a
                      problem, but it seems with pdf there is a problem.

                      Any idea's on how to accomplish this?

                      Take a look at http://www.mvps.org/access/api/api0018.htm.
                      >
                      I'll assume, that if you were to click the pdf file from
                      Explorer, it will open correctly.
                      >
                      Not using explorer --form view of access.
                      Yes, but the same principal applies. Double-Clicking a file in Explorer tells
                      Windows to open that file with whatever program has been associated with that
                      file type. The API code that is found at the link salad provided above would
                      allow you to run code in your Access form that "opens a file with whatever
                      program has been associated with that file type".

                      --
                      Rick Brandt, Microsoft Access MVP
                      Email (as appropriate) to...
                      RBrandt at Hunter dot com


                        Comment

                        • T
                          #7
                          Re: pdf displaying

                          where would I place the code Function fHandleFile(stF ile As String,
                          lShowHow As Long)
                          sorry I'm a novice when it comes to functions

                          this is my current code: (on click of a command button)
                          Private Sub cmdBrowse_Click ()
                          On Error GoTo err_cmdBrowse

                          Me![txtPicture] = GetOpenFile_CLT ("C:\", "Select the File")
                          Me![txtPicture] = LCase(Me![txtPicture])
                          Me!Picture.Pict ure = Me!txtPicture

                          exit_cmdBrowse:
                          Exit Sub

                          err_cmdBrowse:
                          MsgBox Error$
                          Resume exit_cmdBrowse
                          End Sub

                          Take a look at http://www.mvps.org/access/api/api0018.htm.

                          I'll assume, that if you were to click the pdf file from
                          Explorer, it will open correctly.
                          Not using explorer --form view of access.
                          >
                          Yes, but the same principal applies. Double-Clicking a file in Explorer tells
                          Windows to open that file with whatever program has been associated with that
                          file type. The API code that is found at the link salad provided above would
                          allow you to run code in your Access form that "opens a file with whatever
                          program has been associated with that file type".
                          >
                          --
                          Rick Brandt, Microsoft Access MVP
                          Email (as appropriate) to...
                          RBrandt at Hunter dot com

                            Comment

                            Previous template Next
                            Working...