Tag Archive | "use"
How To Search For ID Values In A Different Worksheet With Excel VBA
This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like: SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id I’ll explain the scenario further with [...]
Continue reading...Logitech K750 Review – Best Wireless Keyboard Review
Thursday, September 1, 2011
I was using the Logitech K340 keyboard for around a year. Back then, the Logitech Wireless Solar Keyboard K750 was not released yet. While the K340 keyboard was great at the start, after some time the keys would get stuck. E.g. I would be pressing down on the backspace key, and it would remain stuck, [...]
Continue reading...How To Solve The Problem Of Always Having To Log On To A Network Drive In Windows
Thursday, April 21, 2011
If you try to map a network drive in Windows, and use different user credentials, you’ll realise that you’ll need to always type in the username and password every single session. If you shut down your computer everyday, that means you’ll need to do this on a daily basis. This is horrible too, if you [...]
Continue reading...How To Subtract 2 Count Values Using SQL Statements
Tuesday, March 22, 2011
If you’re developing an application that makes use of SQL statements, you may come across a time when you’ll require to count() values from a table. You may also come across a time when you’ll need to subtract a count() value from another. The good news is that you don’t have to retrieve both count() [...]
Continue reading...How To Share An Wireless/Wi-Fi Internet Connection With a Windows 7 Computer
Tuesday, October 5, 2010
It’s not often, but sometimes you end up in an area where there’s only a wired ethernet connection to the Internet, and you have 2-3 mobile devices that only use Wi-Fi. E.g. a hotel room in China where your 3G devices don’t work. What happens? This is when you’d be happy that you had a [...]
Continue reading...How To Find Out What’s Locking Files or Folders in Mac
Wednesday, August 25, 2010
One of the first problems that I came across the Mac was the “File in use” error that occurred whenever I tried to unmount a hard drive, or unmount a USB thumb drive. It was annoying because I didn’t know how to find the source. In Windows, I would face the same problem too, but [...]
Continue reading...How To Use jQuery with MooTools
Wednesday, May 20, 2009
jQuery and MooTools are 2 great javascript frameworks that allow you to incorporate some really fancy effects on your website. I was using them while I realised that I had to use both of them on a single page at one point. I didn’t realise it then, and took me nearly an hour before I [...]
Continue reading...
Tuesday, October 4, 2011
0 Comments