Print Page | Close Window

Report_MultiCopiesCustomLegends

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=482
Printed Date: 18 Oct 2017 at 12:49pm


Topic: Report_MultiCopiesCustomLegends
Posted By: A.D. Tejpal
Subject: Report_MultiCopiesCustomLegends
Date Posted: 05 Jul 2009 at 5:55pm

Report_MultiCopiesCustomLegends
Explanatory Notes

    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 >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Report_MultiCopiesCustomLegends.zip - uploads/37/Report_MultiCopiesCustomLegends.zip
 
 


-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window