Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 23 Jul 2018 at 8:01am

Topic: Form_TrackBulkSelectionsInDataSheet.mdb
Posted By: A.D. Tejpal
Subject: Form_TrackBulkSelectionsInDataSheet.mdb
Date Posted: 08 Jul 2008 at 11:02pm
This sample db demonstrates tracking of multiple selected rows in a datasheet 
subform. This can be convenient when large number of rows are involved, as there 
is no need for the user to click the check box in each individual row.
It marks the selected blocks of rows by automatic setting of bound check box to 
true in each of the selected rows. The selected rows get highlighted in a distinct 
This approach permits selection of rows even in scattered blocks (i.e. there is no 
compulsion for the selected rows to be contiguous, in one monolithic group).
Even when focus moves away from subform to the parent form, the selection status 
is not lost, as check boxes for all such records continue to hold True value. Visual 
imprint of multiple selections made so far, also continues to get displayed via color 
Any desired operations on the records marked for selection can be carried out by 
clicking appropriate command buttons on the parent form. Action queries if any, 
can use the status of Yes/No field in the criteria clause.
At any stage, if desired, the user can clear all selections by clicking appropriate 
command button on the parent form.

Download Access 2K/XP/2K3: - uploads/37/


Email: -

Print Page | Close Window