Access Shell to Adobe Acrobat Reader?

[Paul7905]

Have an access App. I have an access table in this application that has the file names of several hundred Adobe Acrobat .pdf files.

User would like to be able to click on them and have Access Call Adobe to display the .pdf file.

Is this Possible? If so, does anyone have any VBA sample code that I could see that might accomplish this?

Thanks so much !

Paul in arizona

 

[thornmastr]

Shell "C:\Program Files\Adobe\Acrobat 4.0\Reader\AcroRd32.exe ""path to your
file.pdf"""

Notice that you need double quotes around your file name if it have spaces.

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com