• Form PDF Link (2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Form PDF Link (2003)

    Author
    Topic
    WSmuscle
    AskWoody Lounger
    February 13, 2006 at 5:37 pm #429396

    Here is my issue. I have a form in which a user searches for a specific purchase order, and I then display all the pertinent information in a form. I have a directory on my server which we store PDF copies of our purchase orders. The PDF’s are named the same as the purchase order number (i.e. if a user has po number 123456 open in my Access form, the pdf is named 123456.pdf on the server. Is it possible to link to this in my Access form? So whatever PO is open, the link would point to that individual PDF.

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      February 13, 2006 at 7:47 pm #999945

      You can create a hyperlink to the PDF file: take any label, text box, command button, etc. on the form and use the On Current event of the form to set its hyperlink address property:

      Private Sub Form_Current()
      If IsNull(Me.PONum) Then
      ‘ Disable hyperlink
      Me.lblSomething.Hyperlink.Address = “”
      Else
      ‘ Set hyperlink
      Me.lblSomething.Hyperlink.Address = “C:PDF” & Me.PONum & “.pdf”
      End If
      End Sub

      Substitute the correct names and path.

      Reply | Quote
      • WSmuscle
        AskWoody Lounger
        February 14, 2006 at 5:27 pm #1000146

        Hi Hans,

        It appears the code is working, but the PDF doesn’t stay loaded. It pops up for a second and disappears.

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          February 14, 2006 at 6:48 pm #1000160

          That is probably not an Access problem – hyperlinks are handled by the system, not by Access. Can you open PDF files directly?

          Reply | Quote
          • WSsantosm
            AskWoody Lounger
            February 14, 2006 at 10:08 pm #1000205

            This is my problem as well. But I am running the DB in terminal mode using Citrix. I am searching for an answer and will report back with a solution.

            Thanks,
            Mark

            Reply | Quote
    • WSMarkLiquorman
      AskWoody Lounger
      February 14, 2006 at 1:50 pm #1000064

      You can also use the FollowHyperlink method in the On-Click event of a command button, with code something like:

      Application.FollowHyperLink “server..etc…” & txtPOnum & “.pdf”

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Form PDF Link (2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.