[AccessD] Run a report "invisibly"

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Mon Mar 15 09:26:17 CST 2004


Mark, I would be interested in how you generated the table of contents from
your report.  Could you give a brief overview of what you did and/or sample
code?

-----Original Message-----
From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com]
Sent: Friday, March 12, 2004 11:32 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Run a report "invisibly"


Using the default print dialogue, I recently utilized the "print to file"
option to generate a table of contents from code behind a HUGE report.  I
just deleted the print file afterwards...the generated file was all I
needed.

This sounds similar to your situation.



Mark



-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net] 
Sent: Friday, March 12, 2004 11:05 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Run a report "invisibly"


I went looking for a Print to File setting in VBA and found nothing --
surely there is one? 

Susan H. 

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.

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