[AccessD] Run a report "invisibly"

Hi Barbara

You would still get the "Now printing report ..." message box.

I would bite the bullet and work with the queries and subqueries for
the export. That would probably run way faster too.

/gustav


> 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.