Open Adobe Reader / Acrobat through access

[mattpfc]

Just a quick question really, how could I open Adobe Reader / Acrobat in access. I am using the following coge to open excel but am not sure how to open the Adobe application.


Set oApp = CreateObject("Excel.Application")


thanx in advance

 

[CT Witter]

This will shell out to run your application...

Call Shell("C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.EXE", 1)

If you want to pause code execution to wait until your user has finished with some action, take a look at MS KB Article # 209876 - HOW TO: Determine When a Shelled Process Ends in Access 2000

HTH,
CT