Programatically populate a Report object frame

[Todd Lemen]

How might one programatically pick up a Word document and display its
contents in an Access report at a prescribed location on the report, without
embedding the Word document into a table in Access and picking it up from
there? Is an ubound object frame the right control for this? Is it possible
to programmatically "paste" a Word document into an Access report unbound
object frame?

 

[Tim Ferguson]

Is it possible
to programmatically "paste" a Word document into an Access report
unbound object frame?

You could probably use an event like OnFormat to open the document, get out
the information and poke it into a text box control .Value property.

Don't imagine you'd get very good performance though. What about using the
Word document to read the Jet data instead?

All the best


Tim F

 

[Todd Lemen]

There's a thought. I have been "pushing" the data to a Word document, by
programatically moving to a bookmark, then using Word's Selection object to
"InsertAfter". I hadn't thought of "pulling" the data by having the Word
document read the Jet data...

Thanks, Tim!

TL