I have a command button on a form that looks in a text box for a file name, and uses the code below to open the corresponding PDF:
Private Sub Command82_Click()
Application.FollowHyperlink CurrentProject.Path & "\References\" & Me![PDF Link].Value & ".PDF"
End Sub
I have made it a relative link so that the database and a folder of pdfs can be moved around easily. The problem is that it doesn't work on one of our computers (but it works fine on three or four others). Rather than opening the file, Acrobat opens for a split second and then shuts down. I have even put the database and pdf folder on a CD. The relative link works on my computer but even from the CD, it doesn't work on this particular computer.
Are there some settings (either in Access or Adobe Acrobat) that might prevent the FollowHyperlink application from working?
Private Sub Command82_Click()
Application.FollowHyperlink CurrentProject.Path & "\References\" & Me![PDF Link].Value & ".PDF"
End Sub
I have made it a relative link so that the database and a folder of pdfs can be moved around easily. The problem is that it doesn't work on one of our computers (but it works fine on three or four others). Rather than opening the file, Acrobat opens for a split second and then shuts down. I have even put the database and pdf folder on a CD. The relative link works on my computer but even from the CD, it doesn't work on this particular computer.
Are there some settings (either in Access or Adobe Acrobat) that might prevent the FollowHyperlink application from working?