Output to PDF creates incomplete report

[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 Whipp]

Ken Warthen,

Have you looked at the report in Access to insure it is returning all the
data?

--
Gina Whipp

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

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

 

[Ken Warthen]

Gina,

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

Ken

 

[Gina Whipp]

Ken,

How many pages is the report? I have not seen this problem but my longest
report is 50 pages. Also, what kind of printer?

--
Gina Whipp

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

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

 

[Ken Warthen]

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

 

[Dirk Goldgar]

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

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.

 

[Gina Whipp]

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