Accessing OLE objects

[Martin Whiteside]

Hi,
hope this hasn't been asked too many times before, but I can't seem to get
an answer. I have a database containing several word documents as OLE
embedded objects. I can access them through a bound control on a form, but
what I need to do is automate actions on them. Most importantly I need to be
able to print the docs from code.
I can open word docs from VBA that are on a file server but don't know how
to open ones held within a database. Any help would be appreciated.

Martin Whiteside

 

[Alex Dybenko]

Hi,
here a sample for excel, but believe you can easy modify it for Word
http://alexdyb.blogspot.com/2005/09/how-to-modify-embedded-ms-office.html

 

[Martin Whiteside]

Thanks Alex
The example was good, I was able to modify it for Word.
However, I later realised for simply printing you can embed an object on a
form and use the printout method from within Access.


Me.FrmObject.Activate
Me.FrmObject.PrintOut


this seems to work ok, but your method is better because it allows
manipulation of the document. Thanks very much

Martin