Freezing printing report

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Yannick Turgeon
    #1

    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.OpenRepor t Me.ToPrint, acViewNormal, , Me.MyFilter
    Set obj = Reports(Me.ToPr int)
    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
    Tags: None
    • Tom van Stiphout
      #2
      Re: Freezing printing report

      On Thu, 10 Apr 2008 08:57:30 -0700 (PDT), Yannick Turgeon
      <vendredi5h@gma il.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.OpenRepor t Me.ToPrint, acViewNormal, , Me.MyFilter
      Set obj = Reports(Me.ToPr int)
      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

        Comment

        Previous template Next
        Working...