Word and Excel Objects in Access Reports

[musicloverlch]

I have a problem. I have an Access 2003 report that contains a number
of Word and Excel objects with fancy formatting and spreadsheets, etc.
I have about 20 records that I am having the database cycle through and
create one report per record (I need 20 individual PDFs for e-mailing).
When I use the 'DoCmd.OpenReport "rptAnnualPkg", acViewNormal', Access
prints it before all the Word and Excel objects load and I have reports
with huge blank spaces.

Any ideas?

Thanks in advance,
Laura

[Ted]

I have an Access application which pulls data from an Excel worksheet
and pastes it into a Word document which then prints. It also inserts
an image file if there is one available for that record.
The code used to retrieve the data from Excel (and insert it into the
Word document) controls when my word document (report) prints. I can
retrieve data from a specific cell or copy an entire range of cells and
insert the data into my document. I don't have the name of the book
with me today, but I found a book on VBA and Excel as well as my Access
books that helped me to create the code I needed.

If you still want to use the Access report I am wondering if you have
code in your detail sections OnFormat property. It would seem to me
that any code in there that retrieves data from you Excel file should
hold the report from printing until the code has completed execution
(but we'll leave that from the real experts to determine).