FollowHyperlink Problem

  • Thread starter Thread starter BAL
  • Start date Start date
B

BAL

I am trying to open a pdf file using application.followhyperlink.

I know the file and the pathname exist (tested) and I can open the file from
outside Access. When I try to open from within Access, a window briefly
flashes open and closes.

Code looks like:

Application.FollowHyperlink sFullFilename

I've also placed the actual filename in quotes to see if that made a
difference with the same result.

Application.FollowHyperlink "Z:\BAL\testfile.pdf"

I've also added an error handler to see if I could trap an error, but it is
not triggering.

Any ideas of what to try next would be appreciated.

I am using Access 2003.
 
Very odd. You're sure that it's not just opening the file and that acrobat
isn't getting put in the background?
 
I thought of that and minimized all windows and it is not sitting in the
background nor is there anything in the taskbar.
 
Have you done a CTRL-ALT-DEL to ensure the process isn't running an just not
visible.
--
Hope this helps,

Daniel Pineault
 
BAL said:
I am trying to open a pdf file using application.followhyperlink.

I know the file and the pathname exist (tested) and I can open the file
from
outside Access. When I try to open from within Access, a window briefly
flashes open and closes.

Code looks like:

Application.FollowHyperlink sFullFilename

I've also placed the actual filename in quotes to see if that made a
difference with the same result.

Application.FollowHyperlink "Z:\BAL\testfile.pdf"

I've also added an error handler to see if I could trap an error, but it
is
not triggering.

Any ideas of what to try next would be appreciated.

I am using Access 2003.
Click to expand...

Try:

Application.FollowHyperlink sFullFilename, NewWindow:=True
 
I checked the Task Manager and Adobe is not running anything.

I tried my code on a word document and an excel document and they worked
fine, so it is only pdf. I will take a look at the other code.
 
Same result - a window that flashes open and immediately closes. However
word and excel documents in the same directory work fine. And I've tried
several pdf files in the same directory - all have the same problem. I also
renamed the files to be sure there was no problem with blanks, "_", etc in
the file names. Still same result.
 
I used the code in the second link and it opens pdfs, word and excel
documents (which is what I need).
 
BAL said:
I am trying to open a pdf file using application.followhyperlink.

I know the file and the pathname exist (tested) and I can open the file
from
outside Access. When I try to open from within Access, a window briefly
flashes open and closes.

Code looks like:

Application.FollowHyperlink sFullFilename

I've also placed the actual filename in quotes to see if that made a
difference with the same result.

Application.FollowHyperlink "Z:\BAL\testfile.pdf"

I've also added an error handler to see if I could trap an error, but it
is
not triggering.

Any ideas of what to try next would be appreciated.

I am using Access 2003.
Click to expand...


Make sure you have the latest version of Adobe Reader. One of the recent
versions -- 7.0, maybe? -- manifested this bug.
 
Back
Top