Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 14th, 2007, 11:19 AM
Authorized User
Join Date: Sep 2006
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default Previewing Multiple Reports

I have 2 reports that I would like to preview one after another. While the program generates the report, it throws it into a preview pane. I would like the program to wait for the user to either print or close the previewed report before moving on to the next report. what happens currently is the first report previews and the second report does not even show up..although the code does get processed.

How can I have the program wait for the previewed first report to either be printed or closed before it previews the second report?


Old August 15th, 2007, 07:12 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

When the first report is launched, take the name and any paramters for the second report in a public variable(s) and then on the On Close event of the first report, launch the second. This will not help with the print function, however.

Did that help at all?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Previewing your XSLT - What do you use? tripecac XSLT 3 May 3rd, 2007 05:45 AM
a report containing multiple single page reports hthakkar BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 March 14th, 2006 06:05 PM
Error on previewing a Report penta Access 7 January 9th, 2006 06:17 AM
How to edit report data after previewing report twt Access VBA 2 April 14th, 2005 06:35 AM
cursor; onload, mail or print multiple reports bubblez Access VBA 2 November 3rd, 2003 04:53 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.