unbounded MS Word document in an Access Report

[rmfoley]

All,

I would like to create a professional looking cover sheet with
information loaded from an MS Access Report. I created the cover sheet
in MS Word that includes my company logo, etc.

My only problem is when I insert the Word doc, the sizing is
different. (i.e. the word document's width is 7.5", but when I insert
it into the Access report - it's about 5")

Under the OLE unbounded object Properties, I set the SIZE MODE to
"STRETCH". Resizing does work to an extent, but not good enough.

Other than that, I don't know what else to try.

Am I reinventing the wheel? Is it possible to create a professional
looking report (cover sheet) in the Report - design view using the
tools in the Toll Box?

I've wasted a lot of valuable time... any ideas?

Rob

[Tom van Stiphout]

On 23 Oct 2006 05:09:42 -0700, rm*****@oasis.mediatti.net wrote:

You could just print the coversheet from Word, using Automation.
-Tom.

>All,

I would like to create a professional looking cover sheet with
information loaded from an MS Access Report. I created the cover sheet
in MS Word that includes my company logo, etc.

My only problem is when I insert the Word doc, the sizing is
different. (i.e. the word document's width is 7.5", but when I insert
it into the Access report - it's about 5")

Under the OLE unbounded object Properties, I set the SIZE MODE to
"STRETCH". Resizing does work to an extent, but not good enough.

Other than that, I don't know what else to try.

Am I reinventing the wheel? Is it possible to create a professional
looking report (cover sheet) in the Report - design view using the
tools in the Toll Box?

I've wasted a lot of valuable time... any ideas?

Rob

[Rob]

Tom,

At first I thought you were being a wise-guy, or maybe you didn't
understand my problem...

(Serves me right for thinking too much!)

Turns out you were spot-on!

I did some research and learned about MS WORD field codes and the
DOCVARIABLE as well as OBJECTS (WORD/PPOINT/OFFICE, etc).

I played around a little between ACCESS and WORD and in no time, I was
able to solve the problem.

Thanks for helping me solve my own problem (you learn more that way).

I'm now working on loading PPOINT slides directly from an Access Query
(formatting, Tables, etc). Pretty soon I'll fire my admin office
because everything will be automated :-)

....Just Kidding

Rob

Tom van Stiphout wrote:

On 23 Oct 2006 05:09:42 -0700, rm*****@oasis.mediatti.net wrote:

You could just print the coversheet from Word, using Automation.
-Tom.

All,

I would like to create a professional looking cover sheet with
information loaded from an MS Access Report. I created the cover sheet
in MS Word that includes my company logo, etc.

My only problem is when I insert the Word doc, the sizing is
different. (i.e. the word document's width is 7.5", but when I insert
it into the Access report - it's about 5")

Under the OLE unbounded object Properties, I set the SIZE MODE to
"STRETCH". Resizing does work to an extent, but not good enough.

Other than that, I don't know what else to try.

Am I reinventing the wheel? Is it possible to create a professional
looking report (cover sheet) in the Report - design view using the
tools in the Toll Box?

I've wasted a lot of valuable time... any ideas?

Rob