Open a Adobe acrobat File using vba in Access 1

[Mack2]

How do I open an adobe acrobat file using vba? I have the code below, but it returns the error message "Active x object can not create" I do have a reference set to adobe
THANKS!!!!

Set avCodeFile = CreateObject("AcroExch.AVDoc") 'This is the code file
Set avFormCapture = CreateObject("AcroExch.AVDoc") 'This will be each jpg in turn

'Open the already created code file
avCodeFile.Open DOC_FOLDER & "\test.pdf", "Code File"
Set pdCodeFile = avCodeFile.GetPDDoc

 

[sxschech]

What about using FollowHyperlink method?

 

[Mack2]

Sounds easy enough, but what object is that a method of?
Thanks

 

[sxschech]

Did you look at the examples provided by the VBA help system? I'm using Access 2003.

 

[AlienProbe]

Is the pdf file loading in a OLE Object Controle, such as a Unbound Object Frame ?

 

[Mack2]

The followHyperlink method did it!! THANKS for the tip sxschech!!!
The pdf file is not in an ole object control AlienProbe..thanks for the help

 

[sxschech]

Glad it worked for you.