View a PDF from Access

[pbaldy]

Now you have the path twice. Try the line in post 2 after putting just the file name in the variable.

 

[Dangerous]

Yeah realised that but it still didn't work till I change it to

Private Sub Label1689_Click()

Dim strPDFfile As String
strPDFfile = "D:\MDF Database\Images" & PDFfile

Application.FollowHyperlink strPDFfile


End Sub


PDFfile (controlname) instead of strPDFfile.

Works fine now.

 

[Dangerous]

Thanks for all the help everyone.

 

[Dangerous]

I spotted the errors by adding a hyperlink field and assigning the strPDFfile variable to it. I then saw what was happening and corrected the errors.

I'm learning, slowly but learning. Thanks again.

 

[pbaldy]

Glad you got it working.

 

[Dangerous]

Glad you got it working.

Wouldn't have without your help. Thanks and thanks for the input from everyone else.

 

[pbaldy]

Happy to help!