Embed PDF files in access fields

[SBGibson]

I'm trying to let my users creating and automatically embedding a new pdf files into an access table using a form, without having to make double click or other things like that.
The problem is that an OLE object doesn't allow to open directly Acrobat (just as Imaging does for example) but needs an existing document.
So I made a button where I placed:

Myoleobject.class = "acroexch.document"
Myoleobject.Verb = -2
Myoleobject.OLETypeAllowed = 2
Myoleobject.SourceDoc = "emptydoc.pdf"
Myoleobject.Action = 0
Myoleobject.Action = 7

It seems to be the right way, access opens acrobat correctly, but it opens the same document two times, one for the embedded object and one for the source file.

Someone can help me finding the right way to open acrobat for new documents?
Thanx in advance for helping. Stevie B. Gibson

 

[furbs]

I am tring do print lots of PDF files which I have listed in a hyperlink field, I can get the first PDF file to open but not print, I then want to automatically move to the next file and print and so forth. Is there another way to print these files using access?

 

[TedGrier]

Strange. I can't get it to open even once that way.
Could you send me a sample MDB? tedgrier@grierlabs.com