My friend and I play a game called HeroScape. If you are not familiar with it is great and I am not even into war games that much.
When playing you have a variety of characters to choose from each worth a set amount of points. You determine how many points teams will be worth and then take turns drafting characters into your army for the battle.
Some times choosing a team in the game can be rather time consuming and when you play one on one most times we found we tended to choose many of the same characters, or close to it, each time unless we made a conscious effort not to. Last night we were playing around with using teams chosen at random.
Fast Forward to today and I decide that, being a programmer, making a program to choose our teams for us would be reasonable. Thus I fired up MS Access and threw together a program to randomly select our teams for us based on how many points we wanted the teams to be. It took me about an hour or so to finish. The program is ugly, it is basic, and I did not even bother with record sets or the like. It does not even follow some of the basic naming conventions I typically use resulting in controls with descriptive names like "command3" and "texbox12". Eve the methodology behind the application would be a bad idea in a production environment.
Despite the flaws that I am fully aware of, and would never do with a client's application, it was fun to put together. Perhaps I am odd but, putting the thing together was some of the most fun I can have at a PC. Along the way I got to pick up a neat trick to select random rows that I have never really had the need for before.
So do you program for the the training/practice and money or sometimes for the sheer logical exercise?
PS: Access remain, in my humble opinion, MS's best product. It is a wonderful tool for rapid application development.
PSS: I would not consider myself quite as odd had I not spent the previous day wandering through a forest with a sketch book and water colors.


