rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Mon Mar 15 10:01:59 CST 2004
Well if you really must know, the export to excel from an access report adds field names which I don't want in the electronic version of the report. So I thought that if I could export the data, including the subtotals and totals that I need, to a file, I could use that. Yes, I could open the query that the report is based on and spin through the recordset tallying the totals within the code, but if the report does it for me, why not use that. Also, the user is going to want a nicely formatted printed report so I could do both in one fell swoop. Rusty -----Original Message----- From: John Bartow [mailto:john at winhaven.net] Sent: Monday, March 15, 2004 9:41 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Run a report "invisibly" 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com