Report not printing

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

I have developed a report that is based on data returned from a SQL
Server back end.

In the Activate event I am opening a connection and recordset that
returns the data that I want displayed based on input on a prior form.
In the report, the Detail_Format section cycles through the recordset
until EOF, populating controls with appropriate data.

This all works beautifully and I am able to cycle through the pages of
the report in preview mode etc.

HOWEVER, when I go to print the report, everything seems to run
smoothly, the print queue reports the job as spooling and the job just
disappears, no activity on the laser printer, nothing. This is the
same on any workstation in the office.

We run Windows 2000 and XP, Office 2000 Sp3.

If you need more information, let me know. I hope you can help
because I would really like to close this project out.

TIA
 
I have developed a report that is based on data returned from a SQL
Server back end.

In the Activate event I am opening a connection and recordset that
returns the data that I want displayed based on input on a prior form.
In the report, the Detail_Format section cycles through the recordset
until EOF, populating controls with appropriate data.

This all works beautifully and I am able to cycle through the pages of
the report in preview mode etc.

HOWEVER, when I go to print the report, everything seems to run
smoothly, the print queue reports the job as spooling and the job just
disappears, no activity on the laser printer, nothing. This is the
same on any workstation in the office.

We run Windows 2000 and XP, Office 2000 Sp3.

If you need more information, let me know. I hope you can help
because I would really like to close this project out.

TIA
Click to expand...

The Report Activate event ONLY fires when the report is previewed, not
when it is printed.
Place whatever code you already have in the Activate event in the
Report Open event.
 
Hey fredg, thanks for your response.

Based on your comments I have eliminated the Activate event and moved
all code either to Open or Format sections. As I said, the report
displays correctly in Preview, but does not get to the printer at all.
If I open my print queue the queue just says Spooling, then the job
disappears.

I did not clarify my environment before. I use Access 2000 and
Windows 2000/XP.

Other applications and even other reports print all day long, just not
this one...
 
EGADS!

I cut all of my code from the Activate/Open events (take your pick)
and pasted it into the ReportHeader_Format event and everything
printed correctly!

Also, I found out what it's like to have the entire office stare
quizzically when I danced a jig upon realization of success after
three painful days.

Hopefully this posting helps out someone else in the future.

Here is an excellent resource for anything Access VBA, some good stuff
there.
http://www.accessvba.com
 
Back
Top