By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

unbounded MS Word document in an Access Report

P: n/a
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

Oct 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Oct 23 '06 #2

P: n/a
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
Oct 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.