Form_TrackBulkSelectionsInDataSheet.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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 color. 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 highlighting. 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.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |