Thursday, 10 May 2007

When is Sunday Monday?

Time for an infinite wisdom post now. On my system and in Microsoft Access 2002 the following VBA command:
?WeekdayName(vbSunday)

yields the result
Monday


Awesome!

Why does this happen? Well, it turns out that the help file is right but the actual command in Access doesn't do what it says on the tin.

Description
Returns a string indicating the specified day of the week.

Syntax
WeekdayName(weekday, abbreviate, firstdayofweek)

The WeekdayName function syntax has these parts:
PartDescription
weekdayRequired. The numeric designation for the day of the week. Numeric value of each day depends on setting of the firstdayofweek setting.
abbreviateOptional. Boolean value that indicates if the weekday name is to be abbreviated. If omitted, the default is False, which means that the weekday name is not abbreviated.
firstdayofweekOptional. Numeric value indicating the first day of the week. See Settings section for values.

Settings
The firstdayofweek argument can have the following values:
ConstantValueDescription
vbUseSystem0Use National Language Support (NLS) API setting.
vbSunday1Sunday (default)
vbMonday2Monday
vbTuesday3Tuesday
vbWednesday4Wednesday
vbThursday5Thursday
vbFriday6Friday
vbSaturday7Saturday

Note the help file shows us a third argument that changes the first day of the week. It states that the default is vbSunday (value: 1).

Not true. The default value is 0 and on my system the first day of the week is set to Saturday. This system-wide value is the one that is used to determine which day comes first on those month-at-a-time views such as the one you get by double-clicking the time in the Windows system tray.

Therefore, according to this function on my system, vbSunday is Monday.

Is this the end of Liam?














Well, I've made comment about Liam's somewhat questionable public displays as the loading mascot for Yahoo Mail but even I wouldn't want him to get squished. Poor old Liam.

Wednesday, 9 May 2007

Logitech LX5 Cordless Optical Mouse review ★★★★★★★☆☆☆

Logitech LX5 Cordless Optical Mouse
Logitech LX5 Cordless Optical Mouse


★★★★★ ★★☆☆☆

A comfortable ambidextrous wireless mouse with at least one significant flaw in a harder-to-use-than-it-should-be middle mouse button.

Things I Learned From Dropping My Mouse Onto a Hard Surface

Never drop your mouse onto a hard surface. You can quote me.

Logitech Cordless Desktop for NotebooksI had been the satisfied owner of the Logitech Cordless Desktop for Notebooks but I recently dropped the mouse onto a hard surface from desk height. Mouse still seemed to work but then I noticed that I was having a hard time selecting things and that I was double-clicking items instead of single-clicking them. So, a new mouse was needed.

The LX5


I didn't really want to go to the expense of replacing my whole keyboard and mouse wireless setup. What I wanted was a mouse that would use the same, very handy, receiver as the Cordless Desktop for Notebooks.

Brilliantly, Argos sell the LX5 mouse for £19.95 and I just happened to have £20-worth of Argos vouchers. That feels free. I even got my five pence change!

I worked on the presumption that since this wasn't a Logitech Bluetooth product that it should work with the same receiver as my previous setup. And, after being a bit thick, it did! I didn't even need the supplied setup disc as Logitech have long since made their software support all their keyboard and mouse products. I simply pressed the Connect button on the wireless receiver and the SetPoint software now listed my mouse as the LX5.

Design

The LX5 is a medium-sized mouse with a design that features sides that are more sculptured than they appear in the Logitech promotional photos. It is also symmetrical. This means that the mouse is comfortable for use by left-handed and right-handed people.

Because it is a wireless mouse it is battery powered (2AA Duracell's are supplied, most impressive) and this makes the mouse much heavier than a wired equivalent. However, it is lighter than Logitech's rechargeable mice.

SetPoint Usability

The LX5 works directly in Windows XP without requiring any additional drivers or software installed. SetPoint is the software that controls customisation of Logitech keyboard and mouse products and is a highly recommended install. It is a vast improvement on Logitech's previous software and does everything you want it to.

It keeps itself up-to-date by checking Logitech every so often (I think it is every month or so). It tells you if the batteries in your cordless devices are getting low on juice. Most importantly, it allows you to customise what happens when you use your device. With the LX5 this means that the five functions can be mapped to do just about anything on your computer and that you can set acceleration and pointer speed values. You can also set up a game mode that automatically disables a couple of bits of business when you play games, presumably for greater accuracy or something. The game mode is a feature I've never had cause to use.

attractive, clear and easy-to-use
The SetPoint software is attractive, clear and easy-to-use. You select your category of device along the top (for example, My Keyboard or My Mouse) and then a page of setup or information down the left. Any attached devices appear in a drop-down list allowing you to independently configure multiple mice on the same PC. There are relevant and accurate graphics depicting which mouse and keyboard you have attached and everything is clearly labeled. It's a nice piece of software.

Mouse Usability

The mouse glides well and feels comfortable. The two main mouse buttons are in just the right place as is the mouse wheel. The mouse wheel has a nice feel to it with just the right weight. I haven't yet accidentally flicked the mouse wheel left and right but have used these (largely useless) functions deliberately and found them agreeably weighted also.

Logitech LX5 middle mouse buttonThe main fault with the LX5 now comes to bear. The middle mouse button (ie, clicking the mouse wheel in) is oddly awkward.
middle mouse button is oddly awkward
You need much more pressure to activate the middle mouse button than either the left or right mouse buttons. The feel of the button is entirely different and it almost feels like you have to push it in a different direction to the left and right mouse buttons. Those two buttons have a nice clean click to them. The middle mouse button has a loud cler-unk. In fact, when I first tried to use the middle mouse button I thought that it wasn't there. I needed to push the wheel in much harder; harder than is intuitive.

I wanted my middle mouse button to behave like, well, a middle mouse button
The LX5 feature five customisable functions: left mouse button, middle mouse button, right mouse button, left mouse wheel and right mouse wheel. Of these, the middle mouse button is, by default, bizarrely mapped to a 'zoom' function. This zoom function didn't seem to do anything other than change my mouse pointer to a little magnifying glass. I didn't investigate further as I wanted my middle mouse button to behave like, well, a middle mouse button.

The SetPoint software comes into play here but the middle mouse button setting is tucked away under a drop-down under Other. Never mind, a job you only have to do once. I don't mind that but it is a bit weird.

pinging off into the sunset
Another complaint is the battery cover which requires a leap-of-faith as you push the compartment lock with all your might and hope it doesn't just go pinging off into the sunset. Still, Logitech claim an eight month battery life so you won't be needing access to it all that often. The batteries in the Cordless Desktop for Notebooks mouse lasted a couple of months or so; that was even though I consistently remembered to turn the mouse off whenever I wasn't using it for a period of time.

Conclusion

A comfortable ambidextrous wireless mouse with at least one significant flaw in a harder-to-use-than-it-should-be middle mouse button.

Wednesday, 2 May 2007

Eye-sore

Panasonic logo

Panasonic PT-AX100E
My replacement Panasonic AX100 projector has become faulty. I've only had it three months. I've returned it to Superfi today for repair. I also asked them to ask Panasonic to provide me with the option of a replacement or refund. It will be interesting to see what transpires with that request.

Regarding Superfi, I sent them an email detailing the problem and told them I would be in later today to return it. They made the effort to call me first thing this morning and tell me that their weekly shipment to headquarters was scheduled for 10am and if I got the projector in before that time it could be moved on straight-away. Splendid.

The fault is something to do with the iris mechanism. This controls the amount of light that is emitted from the projector and, according to the manual, contributes significantly to the life of the bulb. Well, the bulb's still going strong...

The most visible symptom is this: the projector turns itself off when you turn it on.

The "Self Check" option in the hidden / system menu places a red light next to the word "Iris".

Looking back now, I can see that I first had an inkling of a problem about a month ago. The picture suddenly lost life and vibrancy. I had been operating the projector on its "Normal" picture setting up to this point and now the picture was underwhelming. It was fixed by changing the picture mode to "Vivid Cinema" and I remained very happy.

A couple of weeks ago, I noticed a slight discolouration of the picture on my browser window (which is predominantly white). The left edge of the picture was pink, the right edge blue. As time went on, this got worse and was joined by the bottom half of the picture being tinged grey. While playing games or watching movies, the discolouration was not noticable but, as I say, when using the computer it is distracting so.

About a week ago, the projector started misbehaving in the first couple of minutes after you switch it on. About thirty seconds to one minute after switching on, the image would suddenly go extremely dim for about half-a-second, then return to normal, then dim again, then return to normal and be fine until the projector was switched off.

A few days after this behaviour manifested itself, it started to switch itself off when turned on about one time in three. Now, it switches itself off every time.

I did manage a workaround however. You turn it on. It turns itself off. You can then hard switch it off using the power switch on the back. Wait a second or two for the light to go off and switch it back on. Power up and the projector will display a picture until you turn it off again. Then you'll have to do this again.

Sunday, 29 April 2007

Spider-Man (2002) movie review ★★★★★★★★☆☆

Spider-Man (2002) logo
★★★★★ ★★★☆☆
It is good, but it is never great. Willem Dafoe is outstanding when not hidden behind a really poor mask, Maguire is fine and Raimi directs with assured pace.
(comment continues below)

DESCRIPTION
Peter Parker is a slightly awkward normal teenager but when he gets bitten by a genetically-enhanced spider during a class field-trip he develops the super-human abilities that make him a Spider-Man.

PEOPLE CREDITS
◦ Tobey Maguire: Spider-Man / Peter Parker
◦ Willem Dafoe: Green Goblin / Norman Osborn
◦ Kirsten Dunst: Mary Jane Watson
◦ James Franco: Harry Osborn
◦ Cliff Robertson: Ben Parker
◦ Rosemary Harris: May Parker
◦ J.K. Simmons: J. Jonah Jameson
• Writer (Original Comic) Marvel: Stan Lee
• Writer (Original Comic) Marvel: Steve Ditko
• Writer (Screenplay): David Koepp
• Director: Sam Raimi

CONTENT
Mild swear words. Extreme violence, unpleasant scenes. Mild sensuality
Classified 12A by BBFC. Persons under the age of 12 must be accompanied by an adult..
Classified 12 by BBFC. Suitable only for persons of 12 years and over.


(comment continues)

"With great power comes great responsibility"

Director Sam Raimi must have had this thought, repeated multiple times in David Koepp's script, running through his mind over and over as he was given the power to take a much-loved comic-book hero to the big-screen.

Thanks to the success of Bryan Singer's "X-Men" comic book heroes have come back into fashion. Sony entrusted Raimi with a budget like nothing he had received before (even relatively expensive movies such as "Darkman" and "The Quick and the Dead" were very reasonably budgeted). His main technical obstacle was the obviously super-human activities of web-slinging and walking up walls and hanging from ceilings. His main directorial challenge would be to suspend the audience's disbelief. How did he do?

Unfortunately, he appears to stumble at the first hurdle. The opening credits sequence is unimaginative and dull, but the biggest mistake was using a theme obviously composed by Danny Elfman. The reason this is a mistake is because it is highly reminiscent of Elfman's career-best work on Tim Burton's classic super-hero movie "Batman" which also featured a brilliant, moody, innovative and completely classy opening credits sequence. Anyone who has seen [Batman] before this movie will sub-consciously be reminded of that classic.

This sense of déja vu happens on numerous occasions. We get multiple Batman moments and at least one Superman moment. The movie doesn't feel original or new. It feels like it never shows us something we haven't seen before. This is despite the fact that we have never seen (in live action, at least) a man swinging through buildings on web strands.

This sounds very critical but I should now reaffirm that the movie is indeed good, very good. Unlike most of the films it is reminiscent of (and its main summer 2002 competition "Star Wars Episode II: Attack of the Clones": Yoda rocks!), this film never has a really great moment. The best thing about Spiderman is Willem Dafoe. His performance as Norman Osborne and The Green Goblin is truly outstanding mixing villainy and humanity with extreme skill. The Thanksgiving dinner he has with Peter, Aunt May, his son and Mary-Jane is just spectacular.

Also the comment regarding Elfman's music may come over as too harsh. After the credit sequence, Elfman does much better and manages to come up with a good Spider-Man theme used at critical moments in the movie to terrific effect.

Swinging :)


  • Brilliantly paced

  • Willem Dafoe

  • Decent story and characterisation

Sticky Mess :(


  • Visual effects are not too good until the final (breathtaking) shot

  • Sound design is surprisingly flat

  • Green Goblin has a rubbish mask which hides Willem Dafoe's mug (a big mistake)

  • Two more falling-while-shooting-a-rope-of-safety-skyward superhero rescues, I was fed up with them before the climax of "Batman Forever" (which, incidentally, is completely repeated here)

Friday, 27 April 2007

Recommended Software: Explorer Breadcrumbs

One of the smarter new features of Windows Vista is the replacing of a simple text address bar for local browsing with an address bar where each part of the folder hierarchy is clickable. This allows you to jump quickly and intuitively to a parent folder.

There is a toolbar for Windows Explorer on Windows XP that provides the same functionality. I have used it for a quite a while now and it's recently been updated to remove a couple of bugs. It uses your current theme (and I use WindowBlinds to skin XP entirely) and simply does exactly what it says it will. Thankfully, it also doesn't require a restart of your computer to install.

Explorer Breadcrumbs at Minimalist

The software is fully functional but the following, entirely reasonable, request is made under the Registration / Licence section:
You're free to install this on any number of machines for any amount of time. We ask that if you find this software useful, that you register it for the low low price of $7.95. That's cheaper than seeing a movie, and we'd really appreciate it.
So, for taking up somewhat less room than Vista's hilarious 12Gb install footprint (Explorer Breadcrumbs is only 333kb) and doing exactly what it says on the tin, I recommend Explorer Breadcrumbs.

Tuesday, 24 April 2007

Well... I clicked it.

I wonder what the most sensationalistic headline possible would be? Here is a contender from the BBC News on BBC.co.uk:
Man cuts off penis in restaurant
The only way this headline could be improved is if you replace "man" with "George Bush" or "The Queen" or something. However, the actual story is rather less impressive than the headline. I had visions of a man coolly laying out his man-meat on a table and removing it with a knife in a Yakuza-like ritual or show of bravado.

Instead:
The man then picked up a kitchen knife and slashed himself across the wrist and groin areas before running back into the restaurant, where he continued to stab himself.
It's clearly a very sad story and very distressing for witnesses and the man himself and the headline is entirely inappropriate... but a guaranteed click.