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?

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


-- 
NTC


"mscertified" wrote:

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

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" wrote:

> 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....
> 
> 
> -- 
> NTC
> 
> 
> "mscertified" wrote:
> 
> > 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?

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


"mscertified" wrote:

> 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" wrote:
> 
> > 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....
> > 
> > 
> > -- 
> > NTC
> > 
> > 
> > "mscertified" wrote:
> > 
> > > 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?

"mscertified" <rupert@tigerlily.com> wrote in message 
news:47EF45B2-0A82-40EB-A54A-C0AAD7771364@microsoft.com...
> 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 

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" wrote:

> 
> "mscertified" <rupert@tigerlily.com> wrote in message 
> news:47EF45B2-0A82-40EB-A54A-C0AAD7771364@microsoft.com...
> > 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 
> 
> 
> 

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


"mscertified" <rupert@tigerlily.com> wrote in message 
news:71285C6D-8E47-4485-A5A8-A4AFCAB55ABD@microsoft.com...
> 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" wrote:
>
>>
>> "mscertified" <rupert@tigerlily.com> wrote in message
>> news:47EF45B2-0A82-40EB-A54A-C0AAD7771364@microsoft.com...
>> > 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
>>
>>
>>