Using record selector on a form to select multiple records
A fellow Access MVP asked if there was a way of using the record selector to select multiple records and perform an action on them. Tom Wickerath, also a fellow Access MVP, responded with How to enumerate selected form records in Access 2003 and in Access 2002. I'd never seen the forms SelTop or SelHeight properties before so was quite intrigued. So I had to find a form in the Granite Fleet Manager where I could implement this functionality.
The code was fairly simple to implement. This gives us some more UI options which allow us to make Access continuous forms operate a bit like Excel worksheets in some simple respects.
Should the user be intrigued by the bulk move button and they didn't select any records they will get the following message.
Other UI Enhancements
Now this form allows the user to return the equipment to the main shop so I designed the UI with two radio buttons labeled Move and Return. You will note the new location field is disabled and some command button captions were changed.
It's possible for equipment to be issued to multiple temporary locations inadvertently. I created an additional All or Multiple Locations set of radio buttons along with the red diamond symbol. This allows the users to very quickly locate all such anomalous data and correct it immediately.
The red diamond is the letter u in the WingDings font. I chose the diamond as it has the most "colour" of any WingDings font entries and is a neutral symbol.
Now I'm not very happy with how the All and Multiple Locations set of radio buttons takes up so much room vertically. And it doesn't fit in well with the rest of the UI on that form or with other forms. But that was the best I could think of at the time.