Report_MultiCopiesCustomLegends |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 05 Jul 2009 at 5:55pm |
Report_MultiCopiesCustomLegends This sample db (meant for Access 2K3 and later) demonstrates printing of multiple copies of a report, each with distinct legend in page footer, as specified by user. The desired legend and its fore color for various copies can be entered / edited in a subform. Out of various planned copies, those required to be included in current print session can be selected via corresponding the check boxes. It is observed that timing plays an important role while opening the report multiple times for generating the desired number of copies. Simple straightforward placement of a series of opening commands for a given report in same code block runs the risk that report instances other than the first one might not get printed. This is because - unless the existing instance is completely closed, any attempt to open a fresh instance is liable to get suppressed. Trying to open the next instance via close event of existing one runs similar risk. As an abundant precaution and in order to circumvent the above pitfall, close event of existing open instance of report is used to activate the timer of calling form. The timer event of the form opens the next instance of report and at the same time, de-activates itself (by setting TimerInterval to 0). These steps continues repeating till all selected copies get printed. In order to facilitate preparatory work with the printer before commencement of each fresh copy, the user is presented with a message box with Yes / No / Cancel option. Clicking Yes prints the copy in hand while clicking Cancel results in cancellation of all remaining copies. If the user is not quite ready, clicking No will defer printing and timer will get reset to present this same message box at regular intervals depending upon print mode (2 sec for preview mode and 4 sec for hard print mode). As and when a given copy gets done, its date and time is displayed in last column of the subform. If the job has been performed <= 8 Hrs ago, it gets highlighted in light green back color, otherwise grey. Page numbering group-wise in x of y style is also demonstrated. This is in addition to the normal overall numbering (Page of Pages). Note - The sample is meant for Access 2K3 and later (as report's OpenArgs feature is not available in Access 2000). Version: Access 2002-2003 file format. References: Nothing extra. Download >>: uploads/37/Report_MultiCopiesCustomLegends.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |