Hyperlink to pdf not working in Access 2003

Running XP SP3:

I have multiple hyperlinks from an Access Table displayed in a Text Box on a Form.

They do NOT open when clicked.

I am able to open them (via Windows Explorer) with Adobe Reader 9 (all Adobe updates installed),  outside of Access.
JohnGalt22Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try to investigate the content of the textbox.. are they wrapped by #
0
ctpmn1Commented:
You should check to see if you can open ANY hyperlinks to pdf's. I have seen this problem occur and can usually be resolved by reinstalling adobe reader.
0
JohnGalt22Author Commented:
No extraneous symbols

This is an actual example:

F:\My Documents\OCTScans\DRUEN^GEORGIA^^^^^19500711^F^20100408114726^OS^Fast Optic Disc^1^Optic Nerve Head Analysis^.pdf
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

JohnGalt22Author Commented:
Uninstalled Reader 9.3
Rebooted
Reinstalled Adobe Reader 9.3.


No change in results:

.pdf file still does not open.

FWIW, the first time I try to open the Hyperlink, the Access Form seems to shift or jump (in place).  Subsequent attempts do not cause this movement.
0
JohnGalt22Author Commented:
"Jump" mentioned above was from "Web" Toolbar opening up at top of form.

Have also discovered that pdf Hyperlinks do not work with ANY MS Office 2003 applications.
0
Rey Obrero (Capricorn1)Commented:
try using the shell command instead.
0
JohnGalt22Author Commented:
I was trying to avoid a command button, preferring instead to just use a single mouse click on the Hyperlink itself.


Or

Are you referring to code that runs when I click on the Hyperlink?
0
ctpmn1Commented:
This is not an issue with your link or Access. This is an issue with Adobe or the extension handler. I would make sure PDF's are set to be opened by Adobe reader. To do this right click on a pdf and go to open with > Choose Program > then Pick adobe reader ( you may have to surf it it C:\program files\ect.) Set it to always use this program.
0
Rey Obrero (Capricorn1)Commented:
in the click event of the textbox, the same as clicking on the content of the textbox

private sub textboxName_Click()

Call Shell ("C:\Program Files\Adobe\Acrobat 9.0\Reader\AcroRd32.exe " & chr(34) & me.textboxname & chr(34),1)

end sub


you may have to change this part
C:\Program Files\Adobe\Acrobat 9.0\Reader\AcroRd32.exe
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnGalt22Author Commented:
"This is not an issue with your link or Access. This is an issue with Adobe or the extension handler. I would make sure PDF's are set to be opened by Adobe reader. To do this right click on a pdf and go to open with > Choose Program > then Pick adobe reader ( you may have to surf it it C:\program files\ect.) Set it to always use this program.Accept Multiple Solutions Accept as Solution"



Yes, as mentioned, I can open all .pdf via Windows Explorer, without a problem.

Adobe Reader has already been set as default program for all .pdf files.
0
JohnGalt22Author Commented:
Yes I had started working a bit with the SHELL syntax earlier.

I will try again, when I get time later.

Thanks for the syntax.

I assume that code is designed to work with varying contents of the Textbox, which do not need to be re-specified each time?
0
Rey Obrero (Capricorn1)Commented:
are the ^^^^^ part of the file name?
0
JohnGalt22Author Commented:
"are the ^^^^^ part of the file name?"

Yes, unfortunately.

These are the filenames output directly from a diagnostic medical instrument.

Although awkward and lengthy, it is simpler just to work with them as they are.
0
JohnGalt22Author Commented:

Call Shell ("C:\Program Files\Adobe\Acrobat 9.0\Reader\AcroRd32.exe " & chr(34) & me.textboxname & chr(34),1)


Great.

With modifications this code works.  I especially like the fact that it functions no matter what the specific contents of the textbox are.

One problem.  The pdf file opens but is immediately hidden by the MS Access Window.  Ideally I would like the pdf to open in a window(preferably off to the side), on top of the MS Access form.  Is there a way to code this type of display?
0
Rey Obrero (Capricorn1)Commented:
change 1 to 3

Call Shell ("C:\Program Files\Adobe\Acrobat 9.0\Reader\AcroRd32.exe " & chr(34) & me.textboxname & chr(34),3)
0
JohnGalt22Author Commented:
That did not change anything.  

PDF opens but immediately is hidden by MS Access window
0
Rey Obrero (Capricorn1)Commented:
you must have a modal/pop-up form opened..
0
JohnGalt22Author Commented:
Pop-up and Modal set to "No" on all three forms that are currently open.

One of the Forms does contain a TabControl, but I don't think that has an effect (?).
0
JohnGalt22Author Commented:
BTW, Once I click on the PDF on the Windows taskbar, it displays as I desire, in a window, on top of, but to the right side of the MS Access form.

I'm trying to avoid unnecessary steps, though.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.