 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / April 2005Hyperlink Issue
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 > I have a form that has contract information. The scanned contracts > are located on a shared network drive and I have the addressed stored [quoted text clipped - 6 lines] > 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).  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) 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. SignatureWayne Morgan MS Access MVP >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 [quoted text clipped - 7 lines] > Application.FollowHyperlink [Agreementloc], , True > End Sub > 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 [quoted text clipped - 3 lines] > 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. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) >> 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 [quoted text clipped - 7 lines] > 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. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) 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? > >> 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 [quoted text clipped - 10 lines] > Now I've tried it, and I see the same problem. Something has changed in > Acrobat Reader 7. 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 >>> 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 [quoted text clipped - 10 lines] > Now I've tried it, and I see the same problem. Something has changed in > Acrobat Reader 7. > 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. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) I've just gone in to adobe... and it's offering me a 7.0.1 update. Might be worth a go. > > Dirk, > > I just happen to have a copy of 6.0 as downloaded from [quoted text clipped - 4 lines] > now. Besides, I use a dial-up connection, so it takes a pretty powerful > incentive to get me to download a file that big. 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. SignatureWayne Morgan MS Access MVP > I've just gone in to adobe... and it's offering me a 7.0.1 update. Might > be > worth a go. 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 [quoted text clipped - 3 lines] > > be > > worth a go. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.