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_PseudoGraphs
  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_PseudoGraphs
    Posted: 30 Jul 2009 at 1:18am

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.

    (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 >>:  uploads/37/


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.