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 customized form [...]
Author Archives: kam onn
My Dell 640m
On sale now at Lelong.com.my.Read more Uncategorized articles
Posted in Uncategorized Leave a comment
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 that I [...]
Posted in work Leave a comment
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, I want other $variables to be substituted with a default value. If [...]
Posted in python Leave a comment
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. Microsoft just doesn’t license you [...]
Posted in work Leave a comment
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 Dim sql As String Set s = ActiveSheet Set qt = s.QueryTables(1) sql = qt.sql Set r = s.Cells(1).SpecialCells(xlLastCell).Offset(1, 1) r = sql End Sub Select your worksheet that contains data from [...]
Posted in work Leave a comment
How to remove a Friend on Facebook
I have a friend on Facebook is not really a friend. By that I mean, he is just collecting people who will agree to be his friend on Facebook and make himself seem popular. He is more interested in marketing himself than being a real friend. If you have such a fiend for a friend [...]