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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SendObject to PDF (acFormatPDF) is creating only the first page of report

Status
Not open for further replies.

Pack10

Programmer
Feb 3, 2010
495
US
I have created a new report in an A2007 db, the report is fine when i print it. Part of the process is to export it via SendObject to PDF and email it out. The first page looks fine, but the second page of the PDF is displaying 1 record with #Error in all the fields.....but when I print it from the reports menu its fine.
 
I have tested further and have noticed that thru the scheduler the PDF is not being created correctly, BUT when run interactively with the app open, it works fine. The email and PDF are created perfectly. Very strange.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top