Help - multiple reports

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I have several reports that are all running off a global
variable in a search form. Each report runs fine
independently. I want the reports to run one after the
other and print (no preview). I tried writing code on the
first report that runs the rest but each report needs
about 3 minutes and I get an error that it can't print a
report that is still running. I received advice to put
each report on the "on close" of the previous report so
that they run one at a time and take as much time as they
need to finish before the next report starts. If I preview
the reports, this works great, but....problem- since the
report is going straight to the printer it doesn't
actually "open" and therefore it never gets to the "on
close" code. Other ideas?? Thanks!
 
I have several reports that are all running off a global
variable in a search form. Each report runs fine
independently. I want the reports to run one after the
other and print (no preview). I tried writing code on the
first report that runs the rest but each report needs
about 3 minutes and I get an error that it can't print a
report that is still running. I received advice to put
each report on the "on close" of the previous report so
that they run one at a time and take as much time as they
need to finish before the next report starts. If I preview
the reports, this works great, but....problem- since the
report is going straight to the printer it doesn't
actually "open" and therefore it never gets to the "on
close" code. Other ideas?? Thanks!
Click to expand...

Christine,

Regarding: >since the report is going straight to the printer it
doesn't actually "open" and therefore it never gets to the "on
close" code. <
I responded to this specifically in a follow up to one of my messages.

The above statement is not true. The events do fire even when
printing, it's just that you cannot use the OpenReport method from a
prining report's event because that causes an error...
Error #2046 "Command or Action OpenReport isn't available now."

I also suggested you place the code to open the other reports in a
FORM code event. It will work from there. Please find your previous
thread and look for my last post.
 
ok-thanks - sorry I misunderstood
-----Original Message-----


Christine,

Regarding: >since the report is going straight to the printer it
doesn't actually "open" and therefore it never gets to the "on
close" code. <
I responded to this specifically in a follow up to one of my messages.

The above statement is not true. The events do fire even when
printing, it's just that you cannot use the OpenReport method from a
prining report's event because that causes an error...
Error #2046 "Command or Action OpenReport isn't available now."

I also suggested you place the code to open the other reports in a
FORM code event. It will work from there. Please find your previous
thread and look for my last post.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top