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 - Form_TrackBulkSelectionsInDataSheet.mdb
  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: Form_TrackBulkSelectionsInDataSheet.mdb
    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/


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.