Output to PDF creates incomplete report

  • Thread starter Thread starter Ken Warthen
  • Start date Start date
K

Ken Warthen

I'm using the DoCmd.Output command to create a PDF file of an Access 2007
report. The code seems to be working okay, except the output file only
contains the first two pages of which in most cases is an extensive multipage
report. There is one entry on the second page where all of the field values
are #Error. Any idea on what I might be doing wrong here. The DoCmd code
line follows.

DoCmd.OutputTo ObjectType:=acOutputReport, ObjectName:="User List Report",
OutputFormat:=acFormatPDF, OutputFile:=strPDFName, AutoStart:=False

TIA,

Ken
 
Gina,

I have. All of the pages with data are visible when the report is opened in
preview mode.

Ken
 
Gina,

The reports can range from a dozen or so pages to more than a hundred. I
don't understand why the printer selection would be relevant when I'm saving
the report in PDF format, but the default printer on the development
workstation is a Canon S330.

Ken
 
Ken Warthen said:
I'm using the DoCmd.Output command to create a PDF file of an Access 2007
report. The code seems to be working okay, except the output file only
contains the first two pages of which in most cases is an extensive
multipage
report. There is one entry on the second page where all of the field
values
are #Error. Any idea on what I might be doing wrong here. The DoCmd code
line follows.

DoCmd.OutputTo ObjectType:=acOutputReport, ObjectName:="User List Report",
OutputFormat:=acFormatPDF, OutputFile:=strPDFName, AutoStart:=False
Click to expand...


I have a vague feeling that I've heard this mentioned before, as a bug.
Make sure you have all patches and service packs applied. If I'm wrong, or
that doesn't fix it, you can use Stephen Lebans' independent solution:

http://www.lebans.com/reporttopdf.htm

It works in Access 2007, as well as the earlier versions he mentions.
 
Ken,

The printer inquiry was because I once had a printer, many moons ago, that
did not have enough memory to hold my report in memory and would print the
first set of pages fine and then start spitting out #ERROR or blank pages or
half printed pages. Once I identified it was a printer issue and switched
to my laser printer (also known as 'the beast') my reports printed
perfectly. Of course, this was some time ago but one never knows and it
can't hurt to ask and make sure that is not the issue.

Also, I see Dirk chimmed in with a idea....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top