Hyperlink Issue

[Guest]

I have a form that has contract information. The scanned contracts are
located on a shared network drive and I have the addressed stored in a table.
I want the hyperlink to open the .pdf of the contract. With the following
code, it opens Adobe and then closes it immediately. When you hover over the
address, it is picking up the correct address. Please help.

Private Sub Agreementhyper_Click()
Application.FollowHyperlink [Agreementloc], , True
End Sub

 

[Dirk Goldgar]

I have a form that has contract information. The scanned contracts
are located on a shared network drive and I have the addressed stored
in a table. I want the hyperlink to open the .pdf of the contract.
With the following code, it opens Adobe and then closes it
immediately. When you hover over the address, it is picking up the
correct address. Please help.

Private Sub Agreementhyper_Click()
Application.FollowHyperlink [Agreementloc], , True
End Sub

Is the field actually defined as a hyperlink field? That might be
messing things up, I suppose, since clicking on it would both open the
document by virtue of its being a hyperlink and because open it because
of your Click event procedure.

I prefer not to use hyperlink fields as such for anything but web pages,
but rather just to use the FollowHyperlink method. That's partly
because Access has a strong tendency to change a document hyperlink into
a web hyperlink, without showing me that it's doing so (because the
hyperlink's display text can be different from the actual URL).

 

[Wayne Morgan]

I don't have a resolution, but I'm getting the same results. It doesn't
matter if the data is defined as a hyperlink type and I click on it or if I
use the FollowHyperlink command with a text string as the path to the file.
However, I believe it used to work. I'm currently running the new Acrobat
Reader v7 and I wonder if that has something to do with the problem. I don't
have an older version to try, but I think I know where there may be one.

 

[Dirk Goldgar]

I don't have a resolution, but I'm getting the same results. It
doesn't matter if the data is defined as a hyperlink type and I click
on it or if I use the FollowHyperlink command with a text string as
the path to the file. However, I believe it used to work. I'm
currently running the new Acrobat Reader v7 and I wonder if that has
something to do with the problem. I don't have an older version to
try, but I think I know where there may be one.

I'm not getting that result, but then I'm using Acrobat Reader 4.0.
Maybe it's version 7. I know someone with both Access and Acrobat
Reader 7 installed, so maybe I can test it.

 

[Dirk Goldgar]

I'm not getting that result, but then I'm using Acrobat Reader 4.0.
Maybe it's version 7. I know someone with both Access and Acrobat
Reader 7 installed, so maybe I can test it.

Now I've tried it, and I see the same problem. Something has changed in
Acrobat Reader 7.

 

[Rob Oldfield]

Nothing really to add to the thread except just general insults about
acrobat reader. I've seen so many nonsensical issues... won't print with a
PS driver, only PCL (sometimes)... causes other - web based - software to
crash (sometimes)... failure to save correctly (sometimes)... does shell
exepath docpath work?

 

[Bill]

Dirk,
I just happen to have a copy of 6.0 as downloaded from
Adobe if you want it. It's almost 9MB, so you'll have to
send me your e-mail address if you want me to send it.
Bill
stanton at jps dot com

 

[Dirk Goldgar]

Dirk,
I just happen to have a copy of 6.0 as downloaded from
Adobe if you want it. It's almost 9MB, so you'll have to
send me your e-mail address if you want me to send it.

Thanks, Bill, that's very thoughtful of you, but I don't need it right
now. Besides, I use a dial-up connection, so it takes a pretty powerful
incentive to get me to download a file that big.

 

[Rob Oldfield]

I've just gone in to adobe... and it's offering me a 7.0.1 update. Might be
worth a go.

 

[Wayne Morgan]

It appears the 7.01 update fixes the problem. I just tried it and it stayed
open; however, it opened behind everything else and I had to bring it to the
front.

 

[Rob Oldfield]

Maybe they'll address that in 7.0.2

It appears the 7.01 update fixes the problem. I just tried it and it stayed
open; however, it opened behind everything else and I had to bring it to the
front.