Bound object frame insert

  • Thread starter Thread starter Robin Hermanussen via AccessMonster.com
  • Start date Start date
R

Robin Hermanussen via AccessMonster.com

Hi,

I have some bound object frames in a list in a form. I've added VBA code
that adds a record to this list. Filling in the fields for the new record
is not a problem, except for the bound object frame (which should contain a
Word document).

So I need to insert a document that I've made with a merge (and written to
a .doc file) into this field. The best way would be to insert it directly.
Can this be done?

Alternatively I could use an update query and then requery the form. How
can I insert a word document directly into the database using a query?

Thanks!

RH
 
Some code to clarify this:

Code: 
With Me.subBrieven.Form.Controls("document")
.SetFocus
.Class = "Word.document"
.SourceDoc = tempFile
.Action = acOLECreateEmbed
End With

If I use ".Action = acOLEInsertObjDlg" it works! But I want it to be
inserted.
 
Back
Top