T
Todd Lemen
I am looking for a bit of advise...
I have an Access Db system in which users establish and store hyperlinks to
MS Word and Excel documents for various purposes. One of the hyperlinks is
the body copy of invoices. (These are long-cycle assemblies, and the users
document change orders, etc, using Word documents...).
At invoicing time, it seems to me I have a couple of alternatives. One
would be to use Access to open an invoice template in Word, populate the
template with some data from the Access tables by using bookmarks in Word,
copy the body-copy-document and paste it in the Word invoice document, and
voila, produce an invoice. Quite "doable" from Access. Let's call this the
"Word-based" approach.
It seems to me that another alternative might be to produce the invoice by
populating an Access report with data from the tables, then picking up the
body copy from Word and pasting it in some sort of object in the Access
report (let's call it the "Access-based" approach). I've been experimenting
with unbound frames for this pupose, but am having no success at
programmatically "pasting" a Word document into an Access report frame. 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?
Thanks all,
TL
I have an Access Db system in which users establish and store hyperlinks to
MS Word and Excel documents for various purposes. One of the hyperlinks is
the body copy of invoices. (These are long-cycle assemblies, and the users
document change orders, etc, using Word documents...).
At invoicing time, it seems to me I have a couple of alternatives. One
would be to use Access to open an invoice template in Word, populate the
template with some data from the Access tables by using bookmarks in Word,
copy the body-copy-document and paste it in the Word invoice document, and
voila, produce an invoice. Quite "doable" from Access. Let's call this the
"Word-based" approach.
It seems to me that another alternative might be to produce the invoice by
populating an Access report with data from the tables, then picking up the
body copy from Word and pasting it in some sort of object in the Access
report (let's call it the "Access-based" approach). I've been experimenting
with unbound frames for this pupose, but am having no success at
programmatically "pasting" a Word document into an Access report frame. 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?
Thanks all,
TL