Open Acrobat report

[itchy]

Hi! I have a database that I am currently working on that will reside on a network server that my users will have access to. I want my users to be able to open up reports that are residing on the same server (that are in Adobe Acrobat format) from within the database. (i.e. they click on a button that will open the file with acrobat reader) I tried using RunApp in a macro but it seems to be having a problem finding the file. All my users are mapped to this server and each user may have a different drive letter corresponding to this server. Is there a way to use a relative path to refer to the file? Or another method all together?

Thanks

 

[david.brent]

I open pdfs in two different ways...

Application.FollowHyperlink FileName (Filename is specified path)

or

Call Shell("C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe " & FileName, vbMaximizedFocus)

As you can see the second needs the path to Acrobat reader which may not be in the same place on each PC.

I have users with different drive letters for the same share on a server. On windows explorer my J: drive is displayed as...

common on 'techsrv9' (J: )

If I had a file on my J: drive called open.txt I would open it using the path...

\\techsvr9\common\open.txt and not J:\open.txt the first works no matter what the drive letter.

Take Care