Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Report_MultiCopiesCustomLegends
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Report_MultiCopiesCustomLegends
    Posted: 05 Jul 2009 at 5:55pm

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.


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.