Print Page | Close Window

Form_SynchronizedSubforms

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=566
Printed Date: 12 Dec 2017 at 10:25pm


Topic: Form_SynchronizedSubforms
Posted By: A.D. Tejpal
Subject: Form_SynchronizedSubforms
Date Posted: 16 Jun 2011 at 2:52pm

Form_SynchronizedSubforms
Updated On:  29-Nov-2011 (Tweaked to suit Access 2010 as well)
Explanatory Notes

    This sample db demonstrates synchronized scrolling of two subforms (both in datasheet view).

    Two modes are covered:
    (a) One way synchronization: Top subform always functions as the master while the other one serves as the slave.
    (b) Two way synchronization: Whichever subform happens to be the active one, functions as the master while the other one serves as the slave.

    Note: For ready identification, the subform currently serving as the slave, has a darker back color as compared to the master.

    For each of the above modes, three alternative styles of scroll synchronization are demonstrated:
    (a) Synchronize horizontal scroll only.
    (b) Synchronize vertical scroll only.
    (c) Synchronize both horizontal and vertical scroll.

    Sample data depicts student's scores in phase 1 (top subform) and phase 2 (bottom subform). For each student, wherever the scores in these two subform happen to differ, the same get highlighted as follows:
    (a) Top subform: Light grey.
    (b) Bottom subform: If value is greater than that in other subform, it gets highlighted in light green. On the other hand, if value is less than that in other subform, it gets highlighted in light pink.

    Note: The above highlights get suitably updated promptly on editing of data in either of the two subforms.

Version:  Access 2000 File Format

Reference:  Nothing Extra 

    Note: This sample db makes use of certain functions in module modGet-SetScrollInfo contained in Stephen Leban's sample db named SetGetScrollbars.
 
Download File >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Form_SynchronizedSubforms.zip -



Print Page | Close Window