February 2009 - Posts

Crystal's video tutorials for Access on YouTube:

Crystal's video tutorials for Access on YouTube

These are more for the person new to Access.

Posted by Tony | with no comments
Filed under:

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.   

BulkMoverMove

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.

BulkMoverMoveMessage

 

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.

BulkMoverReturn

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.  

BulkMoverMultipleLocations

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.

Posted by Tony | 2 comment(s)
Filed under: , ,

Humour: The Microsoft Guide to Valentine's Day

The Microsoft Guide to Valentine's Day  I thought this was reasonably humourous.  

Just catching up on email, blogs, Facebook, newsgroups and other such necessities of life after grandma's funeral.  And I was on dialup for four days.  All the wireless access points in the range of my laptop at that point were all encrypted.  Darn!

Posted by Tony | with no comments
Filed under:

My grandmother passed away

My grandmother passed away last Friday at the age of 92. In many respects her passing was a blessing as grandfather passed away about 10 years ago. She told me many times that she was ready to join him ever since.

While we had some disagreements of course, and sometimes she got a bit irritating, she and grandfather were very good people. I enjoyed my visits with them over the decades.

As a young child they would take us to the Winnipeg Zoo. A highlight was to see the polar bears, monkeys and, of course, the train. We also visited the Manitoba legislature and other scenic places. I can recall one time as a teen we drove south into the US to visit the scene of a tornado which had gone through a forest. It was very impressive seeing the twisted tree trunks bent over a few feet above the ground.

I worked on their farm on and off for two summers when I was in my mid teens. Among other things I drove the tractor cleaning up a ten or 20 year old chicken manure pile. It sounds much worse than it was as the pile was thoroughly composted to black stuff by then. Indeed it steamed in cold mornings.

When I lived out in Winnipeg I frequently visited them especially for Sunday dinner. Her fried chicken, from their own farm and fried potatoes were excellent. I've wondered since then if a 20 or 30 year old cast iron fry pan in daily use makes a difference to the taste. <smile>

After my grandfather passed away she mostly stayed with my aunt in the lower mainland of British Columbia ,a couple of hours drive north of Seattle. So whenever I went to an MVP Summit or visited Microsoft I would spend a few days or a week on either side of the Summit visiting with her. I would give my aunt and uncle a break so they could get out on a "date".

One of her nephews I spoke today to made the blunt comment "She was the last of the aunts and uncles I gave a damn about so yes I'm going to her funeral." And that about sums it up.

RIP Leah G.

Posted by Tony | with no comments
Filed under: