Printing OLE Object (Word Document)

[Matthew hager]

Alright here is what I'm trying to do.

My HR dept. wants to drag and drop resume's into an
access database to be able to print them off later along
with additional info from the db. However, our exec
department is going to be using this application so they
want a button to print the word document directly from
the form. (they don't want them to actually go into word
to print the Resume)

I normally do most of my programming from Visual Basic so
I'm not familiar with how to do this.

Any assistance you all could provide would be very much
appreciated.

Thanks!
mh
..

 

[Matthew Hager]

Just in case anyone else was wondering I figured it out:
This will print the Embedded Object from the form.


'//Where OLEBound23 is your OLEBound Field on the form.
'//The Enabled is very important!!!!
sub click()

Set objWord = Me.OLEBound23.Object.Application.WordBasic
OLEBound23.Enabled = False
Me.OLEBound23.Action = acOLEActivate
objWord.fileprint
OLEBound23.Enabled = false
Set objWord = Nothing

end sub



Thanks!
mh