Can't Print a Report

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I'm having difficulty printing a report. Regardless of
how a invoke the print function - button, menu option,
short cut, the report will not print. I receive the pop
up that indicates # of # pages are printing, but nothing
is actually sent to the printer. Within the same
database, I can print the query the report is based on or
any other information, but I can not get the report to
print. Anyone have any suggestions?
Thanks,
Michelle
 
I'm having difficulty printing a report. Regardless of
how a invoke the print function - button, menu option,
short cut, the report will not print. I receive the pop
up that indicates # of # pages are printing, but nothing
is actually sent to the printer. Within the same
database, I can print the query the report is based on or
any other information, but I can not get the report to
print. Anyone have any suggestions?
Thanks,
Michelle
Click to expand...

You may be generating an error when printing.

For example, if you have coded a Report event to
DoCmd.OpenReport "ReportName",
that will not interfere with the previewing of the report, but it will
interfere with Printing it. You will get the Printing page 1 etc.
message, but the report will not print out.

I would suggest you add error handling to every event that has code in
the report.
On Error GoTo Err_Handler
' Do your coding here
Exit_This_Sub:
Exit Sub
Err_Handler:
MsgBox "Report Header Error #: " & Err.Number & " " &
Err.Description
Resume Exit_this_Sub

If you get an error message, you'll have an indication of where the
problem is occurring.
Change "Report Header Error#: " to the name of the event it is placed
in.
 
Thanks Fred - Unfortunately I'm not that sophisticated of
an Access user. I created a parameter query and then
used the report wizard to create a report. I moved some
of the fields around, and that's about it. If I recreate
the report it will print. I was just trying to avoid
recreating it, redesigning the format, and renaming the
labels. I figured it had to be some thing simple.
 
Thanks Fred - Unfortunately I'm not that sophisticated of
an Access user. I created a parameter query and then
used the report wizard to create a report. I moved some
of the fields around, and that's about it. If I recreate
the report it will print. I was just trying to avoid
recreating it, redesigning the format, and renaming the
labels. I figured it had to be some thing simple.
 
Back
Top