Print Page | Close Window

Report_PseudoGraphs

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=509
Printed Date: 23 Oct 2017 at 6:38pm


Topic: Report_PseudoGraphs
Posted By: A.D. Tejpal
Subject: Report_PseudoGraphs
Date Posted: 30 Jul 2009 at 1:18am

Report_PseudoGraphs
Explanatory Notes

    This sample db demonstrates simulated graphs on access reports, using a single text box for a given series. The following situations are covered:

    1 - Monthly salary as per scales notified from time to time. For a given month and year, the most recent scale notification
upto that month year becomes applicable. Whenever there is a change in salary from one month to the next, different back color is assigned so as to facilitate visual appreciation.

    2 - Room bookings.

    3 - Score sheets for star war games depicting the initial count of units for engine impulse, engine warp-1, engine warp-2 and
superstructure. Depending upon field values in source table, series of numbered boxes are depicted.

    Note:
    (a) Simulation of graph using a single text box is implemented by suitable manipulation of report's MoveLayout property.
    (b) In form F_Salary, the technique for programmatically positioning specific block of records appropriately in the display
window of subform control showing notification of salary scales, is also demonstrated.
    (c) In order to keep sample data for salary scales current with respect to the present year, update query named
Q_SalaryMaster_UpDt  is executed via load event of form F_SwitchBoard. While undertaking practical adaptation of this sample db, this statement should be disabled.

Version: Access 2000 file format.

References: DAO 3.6

Download File >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Report_PseudoGraphs.zip - uploads/37/Report_PseudoGraphs.zip



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

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



Print Page | Close Window