Gustav Brock
gustav at cactus.dk
Fri Mar 12 10:15:41 CST 2004
Hi Susan > I went looking for a Print to File setting in VBA and found nothing -- > surely there is one? Yes but that is for the printer (object) ... not a nice thing to manipulate for this task only. /gustav > 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? >>> 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.