[AccessD] Run a report "invisibly"

Hi, Gustav...

I wish it was a joke!!!

The report is pretty complex, with 12 subreports.  There are hundreds of
calculations performed (in the report as well as all the subreports)--- 
subtotals of 2 or more subreports used in calculations in other subreports,
etc.  The report also outputs data to a spreadsheet.

The data in the report is (almost) exactly what I need to create an export
file requested by the client.  However, I need to have a separate interface
for the export file function.  I would like to execute the report
"invisibly" --- to get the data I need --- and then just create my export
file.

Is it possible to "turn off" the default printer (so the report won't
print), execute the report in Normal mode, then turn the default printer
back on?

Any other suggestions?

Thanks,
Barb

----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, March 12, 2004 8:51 AM
Subject: Re: [AccessD] Run a report "invisibly"


> Hi Barbara
>
> Is this a Friday joke?
> Running a report invisibly without printing it??
>
> Well, if you insist, you must have some action code when opening or
> closing the report; pull that off the report and run it separately.
>
> /gustav
>
>
> > Is there any way to run a report invisibly (i.e., "behind the scenes",
without printing it) in Access 97?  The only modes available are Preview,
Normal, and Design.
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com