[AccessD] Run a report "invisibly"

Thanks, Brett....

I might try this.  I'm going to talk it over with the client.

Barb

----- Original Message ----- 
From: "Brett Barabash" <BBarabash at TappeConstruction.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, March 12, 2004 11:28 AM
Subject: RE: [AccessD] Run a report "invisibly"


> How about running the report in preview mode?
>
> You could use Application.Echo False to disable screen updating (with
> extreme caution to ensure that it gets turned back on when you are done).
>
> Note: By default, only the first couple of pages page format when you
> preview a report.  However, if you bind a textbox to the =[Pages]
property,
> it forces the entire report to execute.  After all this is done, you could
> use DoCmd.Close acReport, <report name> to close it.
>
>
> > 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
>
> --------------------------------------------------------------------------
------------------------------------------
> The information in this email may contain confidential information that
> is legally privileged. The information is only for the use of the intended
> recipient(s) named above. If you are not the intended recipient(s), you
> are hereby notified that any disclosure, copying, distribution, or the
taking
> of any action in regard to the content of this fax is strictly prohibited.
If
> transmission is incorrect, unclear, or incomplete, please notify the
sender
> immediately. The authorized recipient(s) of this information is/are
prohibited
> from disclosing this information to any other party and is/are required to
> destroy the information after its stated need has been fulfilled.
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifies and with authority,
> states them to be the views of Tappe Construction Co.
>
> This footer also confirms that this email message has been scanned
> for the presence of computer viruses.Scanning of this message and
> addition of this footer is performed by SurfControl E-mail Filter software
> in conjunction with virus detection software.
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com