Opening a report hangs and it does not print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 17 Mar 2008 22:56 GMT

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?

Reply to this Message

NetworkTrade - 18 Mar 2008 00:51 GMT

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....

Signature

NTC

> I'm opening a report. I turn hourglass on directly before and off directly
> after. I have a msgbox in the report open event.
[quoted text clipped - 8 lines]
>
> Any ideas how to debug this?

Reply to this Message

mscertified - 18 Mar 2008 01:36 GMT

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.

> well if the query runs fine stand alone.... it must be either the report
> design or your printer driver....
[quoted text clipped - 19 lines]
> >
> > Any ideas how to debug this?

Reply to this Message

NetworkTrade - 18 Mar 2008 02:01 GMT

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....

Signature

NTC

> Report is really simple.
> Can print to this printer fine from MS Word, Wordpad etc.
[quoted text clipped - 23 lines]
> > >
> > > Any ideas how to debug this?

Reply to this Message

Larry Linson - 18 Mar 2008 18:54 GMT

> I'm opening a report. I turn hourglass on directly before and off directly
> after. I have a msgbox in the report open event.
[quoted text clipped - 10 lines]
>
> 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

Reply to this Message

mscertified - 19 Mar 2008 19:12 GMT

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?

> > I'm opening a report. I turn hourglass on directly before and off directly
> > after. I have a msgbox in the report open event.
[quoted text clipped - 18 lines]
> Larry Linson
> Microsoft Office Access MVP

Reply to this Message

Larry Linson - 20 Mar 2008 05:27 GMT

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

> What seems to be happening is:
> User clicks Print button
[quoted text clipped - 29 lines]
>> Larry Linson
>> Microsoft Office Access MVP

Reply to this Message