Freezing printing report

[Yannick Turgeon]

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

[Tom van Stiphout]

On Thu, 10 Apr 2008 08:57:30 -0700 (PDT), Yannick Turgeon
<ve********@gmail.comwrote:

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