[AccessD] Run a report "invisibly"

Mark, I would also be interested in how you did this....Thanks, Barb


----- Original Message ----- 
From: <rusty.hammond at cpiqpc.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, March 15, 2004 10:26 AM
Subject: RE: [AccessD] Run a report "invisibly"


> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com