Freezing printing report

Allo all,

We just upgraded from A97 to A2007 SP1 and we've got a problem that I
cannot solve. When someone wants to print a repport, a form F is shown
for him to choose the printer. Then he prints it. Everything works
fine with all ours repports but one. With this one, when the user try
to print it, the report open behind F (form F is modal) and that's
it!

Some interesting points:
- In that freezed state all F buttons are clickable but nothing
happen. Ex: you can click the "Close" button but the form won't close.
- This problem is not happening on all station (all the same OS
version). But the ones that work, always work, and the ones that
don't, always freeze.
- For the working stations, the report is also display behind F but
only briefly.

When the user clicks on "Print" the program reach this place:
------------------------------------------------------------ --------------------------------------------------------
DoCmd.OpenReport Me.ToPrint, acViewNormal, , Me.MyFilter
Set obj = Reports(Me.ToPrint)
obj.visible = False
------------------------------------------------------------ --------------------------------------------------------

For the not-working stations, the execution never exit the "DoCmd"
line and then never reach the "Set obj" one.

Anybody could give me some hint/suggestion to solve this problem? At
what should I look?

Thanks for your time.

Yannick

Re: Freezing printing report

On Thu, 10 Apr 2008 08:57:30 -0700 (PDT), Yannick Turgeon
wrote:

Kudos for this very good bug report.
It might be a timing issue.
Those last two lines are very unusual. Comment them out and see how
you fare.

-Tom.



>Allo all,
>
>We just upgraded from A97 to A2007 SP1 and we've got a problem that I
>cannot solve. When someone wants to print a repport, a form F is shown
>for him to choose the printer. Then he prints it. Everything works
>fine with all ours repports but one. With this one, when the user try
>to print it, the report open behind F (form F is modal) and that's
>it!
>
>Some interesting points:
>- In that freezed state all F buttons are clickable but nothing
>happen. Ex: you can click the "Close" button but the form won't close.
>- This problem is not happening on all station (all the same OS
>version). But the ones that work, always work, and the ones that
>don't, always freeze.
>- For the working stations, the report is also display behind F but
>only briefly.
>
>When the user clicks on "Print" the program reach this place:
>----------------------------------------------------------- ---------------------------------------------------------
> DoCmd.OpenReport Me.ToPrint, acViewNormal, , Me.MyFilter
> Set obj = Reports(Me.ToPrint)
> obj.visible = False
>----------------------------------------------------------- ---------------------------------------------------------
>
>For the not-working stations, the execution never exit the "DoCmd"
>line and then never reach the "Set obj" one.
>
>Anybody could give me some hint/suggestion to solve this problem? At
>what should I look?
>
>Thanks for your time.
>
>Yannick

Re: Freezing printing report

Tom van Stiphout wrote:
> On Thu, 10 Apr 2008 08:57:30 -0700 (PDT), Yannick Turgeon
> wrote:
>
> Kudos for this very good bug report.
> It might be a timing issue.
> Those last two lines are very unusual. Comment them out and see how
> you fare.
>
> -Tom.

Since it appears he wants to hide the report, he could open the report
hidden.

docmd.OpenReport "x",,,,acHidden

I'm not sure why one would want to open a report to be printed as
hidden. I can understand opening it in design mode and enumerating the
controls or whatever else one can do in design mode.





>
>
>
>
>>Allo all,
>>
>>We just upgraded from A97 to A2007 SP1 and we've got a problem that I
>>cannot solve. When someone wants to print a repport, a form F is shown
>>for him to choose the printer. Then he prints it. Everything works
>>fine with all ours repports but one. With this one, when the user try
>>to print it, the report open behind F (form F is modal) and that's
>>it!
>>
>>Some interesting points:
>>- In that freezed state all F buttons are clickable but nothing
>>happen. Ex: you can click the "Close" button but the form won't close.
>>- This problem is not happening on all station (all the same OS
>>version). But the ones that work, always work, and the ones that
>>don't, always freeze.
>>- For the working stations, the report is also display behind F but
>>only briefly.
>>
>>When the user clicks on "Print" the program reach this place:
>>---------------------------------------------------------- ----------------------------------------------------------
>> DoCmd.OpenReport Me.ToPrint, acViewNormal, , Me.MyFilter
>> Set obj = Reports(Me.ToPrint)
>> obj.visible = False
>>---------------------------------------------------------- ----------------------------------------------------------
>>
>>For the not-working stations, the execution never exit the "DoCmd"
>>line and then never reach the "Set obj" one.
>>
>>Anybody could give me some hint/suggestion to solve this problem? At
>>what should I look?
>>
>>Thanks for your time.
>>
>>Yannick