Open Embedded Word Doc

[ck4794]

so i found this code out there to open a word doc:

Private Sub Command3_Click()
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim filepath As String


'Open Word
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True


filepath = Me.forms_FileData
'Open the file
Set wrdDoc = wrdApp.Documents.Open(filepath)
End Sub

The problem is all the example i found opened a file somewhere on the computer, where as I have the word doc attached.

I'm using a continuous form, "frmForms" (don't judge me for the name, i know this is asking for confusion but i got it)
source is a table "optForms"
attachment field is "File", PK is standard autonumber ID field.

Can anybody help me with this?

[June7]

Bing: access open embedded word document from attachment field

http://support.microsoft.com/kb/123859/en-us

Note that the code assumes document is embedded in an OLEObject type field, not Attachment type field. So this might not work with Attachment. The only other way I know to work with documents in Attachment field is to save them out to a folder, open for editing, the save back into the Attachment field. Here is code for managing content of Attachment field: http://blogs.office.com/b/microsoft-...cess-2007.aspx

[NTC]

if by 'embedded' you mean attempting to open Word inside an Access form object - that really is not a good approach. Attempting to embed any full fledged application (Word or otherwise...) inside an Access form object just is not practical. IMO