How can I insert a a new (blank) ms word object into Access OLE fi

[Guest]

I want to create an MS Word object in each record of a large table and
populate each record with text records from a file. I want to do this
through macros or VB. So far, I can only seem to do this by using the menu
bars (insert object, "create new" dialog box, "select 'microsoft word
document', cut the text , paste the text). Most difficult part is that I
can't get around the "create new" dialog box where I have to select the MS
word document item.

Anybody done this with VB. It's too many records to cut and paste. Thanks.

 

[John Nurick]

You can do this by putting a bound object frame control on a form and
writing VBA to control the form and the object frame.

But whatever the business problem, storing textual data in Word
documents embedded in an Access table is almost certainly the wrong
solution, for too many reasons to list. If you post to the
tablesdbdesign newsgroup with a description of the problem domain you're
likely to find a less troublesome approach.

 

[Guest]

John thanks - I'll go to the news group on the application requirment. Can
you provide a VBA code example of how to insert a word object into a column
in a table without having to respond to a "pastespecial" dialog box? I'm
trying to avoid 1300 manual insert operations.

 

[John Nurick]

The only way I know to do this is by automating a form containing a
bound object frame. The object frame knows how to "package" the Word
document into an OLE field. Look up help on the object frame's Verb and
Action properties.