Opening a report hangs and it does not print

[mscertified]

I'm opening a report. I turn hourglass on directly before and off directly
after. I have a msgbox in the report open event.

I get the hourglass and a message 'opening report'. The report never prints
and the hourglass never goes away. Have to terminate Access to get out. The
msgbox in report open event does not display.

The last thing I changed was the feeding query which runs fine outside the
report.
The report is opened with a filter.

Any ideas how to debug this?

 

[NetworkTrade]

well if the query runs fine stand alone.... it must be either the report
design or your printer driver....

incoherent behavior by a report (including not opening...) can definitely be
caused by a bad printer driver....even when one has no intention of
printing..just trying to open in preview mode....

if your report design is real deep & complex and your hunch is that it is
the report itself...make a copy and start stripping out controls until it
opens...and see if you can ID the bad boy....

 

[mscertified]

Report is really simple.
Can print to this printer fine from MS Word, Wordpad etc.
It all worked until I changed the query - but the query works fine standalone.

 

[NetworkTrade]

well my run-in with a bad print driver the printer worked fine for Word docs
and everything else.... put the application on another PC with Access; if
the report works then it surely is the print driver....

if it still doesn't work then at least you know that much...

sub report ? a query that runs good standalone can be alot slower driving a
subreport too....

seems to me that I've had bad report behavior where I accidentally changed
or redefined a field name ...can't remember the details anymore...but
stripping out fields/controls finally came across the trouble maker....

 

[Larry Linson]

I'm opening a report. I turn hourglass on directly before and off directly
after. I have a msgbox in the report open event.

I get the hourglass and a message 'opening report'. The report never
prints
and the hourglass never goes away. Have to terminate Access to get out.
The
msgbox in report open event does not display.

The last thing I changed was the feeding query which runs fine outside the
report.
The report is opened with a filter.

Any ideas how to debug this?

What happens if you do NOT set the hourglass? You wouldn't just happen to
have accidentally turned "Echo" off, would you? Have you tried using
Debug.Print, instead of MsgBox, and having the Immediate window open when
you start the Report? What version of Access are you using?

Larry Linson
Microsoft Office Access MVP

 

[mscertified]

What seems to be happening is:
User clicks Print button
Print routine saves the record
Before Update event is triggered
A Msgbox prompt is issued for user input
Prompt never displays, database hangs with hourglass.
Why would Msgbox not appear?

 

[Larry Linson]

Are you displaying the Report in Preview, or going directly to Print?
Unless I am debugging, I've never had a need to display a MsgBox from within
a Report, so don't have much personal experience in this area.

(And, at this particular time, do not have the time and energy to go
research it to see if I can reproduce what you're observing -- sorry.)

Larry Linson
Microsoft Office Access MVP