Problem with followhyperlink and PDF (adobe)

[dwichmann]

Have a strange problem, I am using an application.followhyperlink command to launch quotations from a record in my database. This works fine with all document types except for PDF's.

If Left(Form_FrmQuoteAmend.webnumber, 3) = "WEB" Then
quotelink = "Y:\CRM\Quotes\"
qref = Form_FrmQuoteAmend.webnumber & ".pdf"
qlink = quotelink & qref
application.followhyperlink qlink

the extension document changes when looking for word or excel documents but the code is the same.

I have even tried replacing the qlink and having the follwhyperlink look for the actual document as below

application.followhyperlink "Y:\CRM\Quotes\test.pdf"

Obviously i placed a document called test.pdf in the correct file location.

I am using windows XP, access 2003 and acrobat 7.0

please help.

 

[smedvid]

Just one minor suggestion, that may not help... I avoid using hard-coded drive letters and opt for UNC notation. In your case, Y: would be represented by \\ServerName\NetworkShare\CRM\Quotes\test.pdf.


A couple of more thoughts:
- Can you cut and paste Y:\CRM\Quotes\test.pdf into Internet Explorer and will it open?
- Can u open Y:\CRM\Quotes\test.pdf from Windows Explorer? Perhaps check the File Extension Launch Association to insure that Adobe is the default for opening pdf files.
- Do you have a recent version of Adobe Reader?

htwh,



Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[dwichmann]

thanks for reply smedvid, unfortunately did not work, i have also tried pointing to the file on my local drive but it will not launch the file. One thing i have noticed though is that acrobat does open but shuts in literally a millisecond. just enough to cause a flash on the screen.

the file will open when the path is typed into the address bar of windows or internet explorer.

I have the most recent version of acrobat reader.

 

[smedvid]

Check your file association settings under Windows Explorer and re-select Adobe Reader. Open Windows Explorer, select Tools - Folder Options - File Types...

Or if that does not work, Un-install and then Re-Install Adobe Reader.

Also, have you tried this on another PC to confirm that the issue is environmental in nature to the PC that is unable to launch the PDF?

htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[dwichmann]

Thanks again, got to the bottom of it now, sort of. Was using the latest version of Acrobat (version 7). This does not work, i reinstalled version 6 and everything is fine.