[AccessD] Run a report "invisibly"

Jim Lawrence (AccessD) accessd at shaw.ca
Sat Mar 13 04:40:08 CST 2004


Hi Barbara:

Why not schedule the reports for over-night or at off hours...or have the
print job re-directed to a back room printer. One of the old computers could
be setup for just running a specific set of print jobs.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan
Sent: Friday, March 12, 2004 7:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [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

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list