Author Archives: karl.kranich

Dotnetnuke Menu Bar Broken in Firefox

menubarWhen our users started upgrading to Firefox 3.0.10, they began noticing that our Dotnetnuke intranet’s menu bar was broken — only “Home” showed up, not the rest of the page titles.

It turns out that DNN uses a config file to tell it what capabilities the various browser versions support. For some reason, the user agent string from Firefox 3.0.10 isn’t recognized.

I empathize with the arguments on the DNN forums that it’s not a good practice to maintain a table like this, but I’m not going to try to rewrite DNN. Since I’m not worried about really old versions of Firefox accessing our Intranet site, my fix was to edit the file \js\ClientAPICaps.config and add this to the first section:

browser contains="Firefox"

Word Mail Merge fails to see MS Access data source

transfertextWe have an Access database that has been used for years as a data source for merging Word documents.? A button in the Access app would run a MakeTable query and then launch Word, which would open a document that looked to the table as a data source.

Two weeks ago, the mail merge documents began refusing to see the data source.? I read all of the tips about using Internet Explorer’s security settings to put the network path in the Intranet or Trusted Sites zones.? That actually helped on some machines, but not most.

My solution was to use the VBA (Visual Basic for Applications) function “TransferText” to export the table to a text file on the local hard drive.? I then reconfigured all of the merge documents to look to that local file.? The basic instructions can be found here.

VNC to Mac OS 10.5 from Windows

I’ve been trying for a while to get the Mac “Screen Sharing” to work. I want to control the Mac from a Windows Vista machine. Even though Screen Sharing is just a VNC server, my RealVNC client would seem to connect for a split second and then the connection would go away.

I finally found the solution: in the VNC client (vncviewer) options, set the encoding to “Hextile” and the color level to “Full”. Now it connects fine!

vncviewer settings

Taxes

Nobody seems to know who wrote this originally, and there are many versions out there.? Regardless, it makes you think…

Suppose that every day, ten men go out for beer and the bill for all ten comes to $100. If they paid their bill the way we pay our taxes, it would go something like this:

The first four men (the poorest) would pay nothing.
The fifth would pay $1.
The sixth would pay $3.
The seventh would pay $7.
The eighth would pay $12.
The ninth would pay $18.
The tenth man (the richest) would pay $59.

So, that’s what they decided to do. The ten men drank in the bar every day and seemed quite happy with the arrangement, until one day, the owner threw them a curve. “Since you are all such good customers,” he said, “I’m going to reduce the cost of your daily beer by $20.” Drinks for the ten now cost just $80.

The group still wanted to pay their bill the way we pay our taxes so the first four men were unaffected. They would still drink for free. But what about the other six men – the paying customers? How could they divide the $20 windfall so that everyone would get his “fair share?” They realized that $20 divided by six is $3.33. But if they subtracted that from everybody’s share, then the fifth man and the sixth man would each end up being paid to drink his beer. So, the bar owner suggested that it would be fair to reduce each man’s bill by roughly the same amount, and he proceeded to work out the amounts each should pay.

And so:
The fifth man, like the first four, now paid nothing (100% savings).
The sixth now paid $2 instead of $3 (33%savings).
The seventh now paid $5 instead of $7 (28%savings).
The eighth now paid $9 instead of $12 (25% savings).
The ninth now paid $14 instead of $18 (22% savings).
The tenth now paid $49 instead of $59 (16% savings).

Each of the six was better off than before. And the first four continued to drink for free. But once outside the restaurant, the men began to compare their savings.

“I only got a dollar out of the $20”, declared the sixth man. He pointed to the tenth man, “but he got $10!”
“Yeah, that’s right”, exclaimed the fifth man. “I only saved a dollar, too. It’s unfair that he got ten times more than I!”? “That’s true!!” shouted the seventh man. “Why should he get $10 back when I got only two? The wealthy get all the breaks!”

“Wait a minute,” yelled the first four men in unison. “We didn’t get anything at all. The system exploits the poor!”

The nine men surrounded the tenth and beat him up.

The next night the tenth man didn’t show up for drinks, so the nine sat down and had beers without him. But when it came time to pay the bill, they discovered something important. They didn’t have enough money between all of them for even half of the bill!

And that, boys and girls, journalists and college professors, is how our tax system works. The people who pay the highest taxes get the most benefit from a tax reduction. Tax them too much, attack them for being wealthy, and they just may not show up anymore. In fact, they might start drinking overseas where the atmosphere is somewhat friendlier.