Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multipage Word Doc only displaying first page?? 1

Status
Not open for further replies.

ottograham

Technical User
Mar 30, 2001
109
US
Can you insert a Word Document (linking or embedding) that is multipage? I've inserted a Word Doc/ Create from File ... and all I get is the first page of the document.

Is there a limitation to size of object or number of pages?

How do I get the entire 15 page document to appear?

Thanks in advance for any help you can offer.

Scott Graham
 
An access report is limited to 22 inches of vertical and horizontal space. The word document's 15 pages would have to be less than that limitation in order to print all the pages. If you need a word document that long as an addendum to a report you can write code that prints the report automatically out of access for you. Here's the code:

[tt]
Dim WordObj As Object
Dim WordDoc As Object
Dim DocToPrint As String

Set WordObj = CreateObject("Word.Application")

DocToPrint = "C:\MyPath\MyWordDocument.doc"
With WordObj
.Documents.Open DocToPrint
Set WordDoc = WordObj.ActiveDocument
End With
WordDoc.PrintOut Background:=False
WordDoc.Close

WordObj.Quit
Set WordObj = Nothing
[tt]

HTH Joe Miller
joe.miller@flotech.net
 
Joe:

Thank you. I didn't realize there was a limit to the report length. I think I can break the large report down into smaller sections, which should work fine.

I am using your code for another problem I've encountered.

Thanks again.

Scott Graham
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top