Recently I had to review some very large registry files (.reg). Trouble was when the file was large, VIM somehow displays also the control characters. This made the file difficult to read. The solution is to delete all the control characters with :%s/[[:cntrl:]]//g and voila: [...]
Author Archives: kam onn
Microsoft’s support disappoints !! My experience of fixing “Class not registered” for mscomct2.ocx control after Microsoft support staff abandoned the case
I had a very disappointing experience of dealing with Microsoft Dynamics support. Last month, my client started deploying Meeting Room Manager. I first noticed that the customization on my PC stopped working and soon the problem spread to the citrix server. The symptoms of the problem was that when I fired up a [...]
My Dell 640m
On sale now at Lelong.com.my.Read more
Uncategorized articles
Clip Path for Windows 64
One of the things I missed when I moved to Windows 64 bit was ClipPath. I looked for a ClipPath utility for Windows 64 and found something hopeful but the file was missing. Then I came across Tim Sneath’s Windows Vista Secret: Copy as Path. I promptly tried shift right click and found [...]
string.Template with default substitution value
I wanted a string.Template class that will substitute placeholders with a default value if the mapping is not provided. For example, say I create a template A template with $value1, $value2 When I substitute this template with values, say I provide only $value1, [...]
Windows 7 upgrade
According to this piece of news, Windows 7 upgrade from Vista can take a almost a day !Whoa ! I was tempted to get a Vista system with upgrade option but now I would not.Slashdot Technology Story | Windows 7 Upgrade Can Take Nearly a DayA clean 32-bit install on what Microsoft calls ‘high-end hardware’ [...]
Windows 32 bit’s 4 GB RAM limit
A very bright Geoff Chappel looked into Microsoft’s claim and said this: That 32-bit editions of Windows Vista are limited to 4GB is not because of any physical or technical constraint on 32-bit operating systems. The 32-bit editions of Windows Vista all contain code for using physical memory above 4GB. [...]
How to view the query the SQL for an Excel worksheet with data source
Save the following code in a module. Sub print_query_table_sql()
Dim s As Worksheet
Dim qt As QueryTable
Dim r As Range
[...]