Form PDF Link (2003)

Topic

New Reply

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

Replies

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

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

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

Reply | Quote

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

(Edited by HansV to make URL clickable – see Help 19. A link is very easy to create and much more user-friendlly)

I found the solution…

http://support.microsoft.com/default.aspx?…kb;en-us;897755%5B/url%5D

I downloaded the appropriate Adobe update, and restarted Access. Everything is working fine now. Let me know if this solves your problem. If not, I’ll do some more research.

Reply | Quote

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