John Bartow
john at winhaven.net
Mon Mar 15 09:40:47 CST 2004
I think this has to be my all time favorite thread where my first reaction was "why would you want do this?" :o) Interesting! John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of rusty.hammond at cpiqpc.com Sent: Monday, March 15, 2004 9:26 AM To: accessd at databaseadvisors.com 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