[AccessD] Report printed or previewed

    You are most welcome Steve! Nice of you to share the follow up.

Best wishes,
A.D.Tejpal
------------

  ----- Original Message ----- 
  From: Steve Schapel 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, July 22, 2008 03:40
  Subject: Re: [AccessD] Report printed or previewed


  Thank you very much for this ingenious idea, A.D.

  Expecting there to be no way, I have now tacked the problem in a 
  different way.  Besides, some of the reports I was looking at would be 
  only 1 page.

  Nevertheless, your answer has given food for thought, and added to my 
  knowledge and understanding of the report process.

  Regards
  Steve


  A.D.Tejpal wrote:
  > Steve,
  > 
  > One way for programmatic detection of report's open status (Print or
  > Preview) could be by checking whether the print event of page header
  > on page 2 has fired closely after Page event on page 1. Of course
  > this presumes a report sized more than one page.
  > 
  > Sample code in report's module, as given below, should be able to do
  > the needful.
  > 
  > Detecting print preview status could be somewhat trickier, as the
  > report can sit on page 1 itself for a prolonged period. Thus we can
  > not keep waiting for the print event on page 2 to fire. For tackling
  > this situation, we can use form's Timer event. Sample code in form's
  > module, as given below, in conjunction with the global variable in
  > general module as shown, should be able to detect print preview
  > status of the report.