By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

FollowHyperlink not working with pdf file

P: 44
There is a screen for printing various form in an application I have. Some of them integrate data into the forms, but a few are just there so the users can grab standard forms while they're in the screen. So I have been using command buttons that say what form it will open. The code that goes with the command button is as follows:

Dim Path As String
Path = DLookup("[Path]", "Region Data") & "\Common"
strInput = Path & "\ECIS.pdf"
Application.FollowHyperlink strInput, , False

I just had to change this particular form. The old form was a Word document and the new form is a pdf document. So all I changed was the extension in the code form ".doc" to ".pdf". It worked fine before, now it just opens Acrobat Reader, but doesn't bring the document in. And that, my friends, is my problem.

P.S. Don't worry about the path definition - I'm sure this is correct.

Thanks you.
Apr 11 '08 #1
Share this Question
Share on Google+
5 Replies


nico5038
Expert 2.5K+
P: 3,072
Strange problem, looks like the problem is Acrobat-Reader and not Access related.
Are you sure the correct version of the reader is installed ?

An alternative might be to start the application using the SHELL() function.

Nic;o)
Apr 13 '08 #2

ADezii
Expert 5K+
P: 8,638
There is a screen for printing various form in an application I have. Some of them integrate data into the forms, but a few are just there so the users can grab standard forms while they're in the screen. So I have been using command buttons that say what form it will open. The code that goes with the command button is as follows:

Dim Path As String
Path = DLookup("[Path]", "Region Data") & "\Common"
strInput = Path & "\ECIS.pdf"
Application.FollowHyperlink strInput, , False

I just had to change this particular form. The old form was a Word document and the new form is a pdf document. So all I changed was the extension in the code form ".doc" to ".pdf". It worked fine before, now it just opens Acrobat Reader, but doesn't bring the document in. And that, my friends, is my problem.

P.S. Don't worry about the path definition - I'm sure this is correct.

Thanks you.
'Path' is a Property that is used to determine the location of information stored through the CurrentProject or CodeProject Objects of an Access Project or Database. It should never be used within a Variable Declaration, try changing it.
Apr 13 '08 #3

ADezii
Expert 5K+
P: 8,638
There is a screen for printing various form in an application I have. Some of them integrate data into the forms, but a few are just there so the users can grab standard forms while they're in the screen. So I have been using command buttons that say what form it will open. The code that goes with the command button is as follows:

Dim Path As String
Path = DLookup("[Path]", "Region Data") & "\Common"
strInput = Path & "\ECIS.pdf"
Application.FollowHyperlink strInput, , False

I just had to change this particular form. The old form was a Word document and the new form is a pdf document. So all I changed was the extension in the code form ".doc" to ".pdf". It worked fine before, now it just opens Acrobat Reader, but doesn't bring the document in. And that, my friends, is my problem.

P.S. Don't worry about the path definition - I'm sure this is correct.

Thanks you.
'Path' is a Property that is used to determine the location of information stored through the CurrentProject or CodeProject Objects of an Access Project or Database. It should never be used within a Variable Declaration, try changing it. It is also the name of a Field in the Region Data Table leaving a lot of room for ambiguity.
Apr 13 '08 #4

P: 44
'Path' is a Property that is used to determine the location of information stored through the CurrentProject or CodeProject Objects of an Access Project or Database. It should never be used within a Variable Declaration, try changing it. It is also the name of a Field in the Region Data Table leaving a lot of room for ambiguity.
I changed the variable name to PathA and it did the trick. Thanks. Sorry it took me so long to reply. I've been out of the office for a while.
Apr 24 '08 #5

ADezii
Expert 5K+
P: 8,638
I changed the variable name to PathA and it did the trick. Thanks. Sorry it took me so long to reply. I've been out of the office for a while.
Not a problem, glad you were able to arrive at the solution.
Apr 24 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.