How to Increase and Decrease Volume by Quarter Steps in Mac OS X

Up until Mac OS X Lion you could use a handy shortcut to increase and decrease the system volume by quarter steps by doing the following: Option + Shift + Volume Up to increase volume by a quarter step, Option + Shift + Volume Down to decrease volume by a quarter step. But what if you are …

Continue reading

Windows Phone 8 Stuck on Preparing to Install 100%

Here is a quick tip for those of you with Windows Phone 8 handsets that receive major software updates. During the process of preparation you may see that your device sits on part of the update saying: Preparing to Install 100% Apparently, this is normal and all you have to do is wait between ten …

Continue reading

Get a Better Mobile Plan in Thailand

Samsung Galaxy S III

Just been on holidays in Thailand for about a week and with any international trip there is the issue of remaining in touch with those back home just in case. Using your mobile overseas can be costly and while there are alternatives such as Truphone sometimes the local offering may be even better. Upon reaching the …

Continue reading

Wi-Fi Done Right @ The Peninsula Hotel, Bangkok

In the past, I have written about the woes of international travel when it comes to keeping connected online with many hotels choosing to slug guests heavily for Wi-Fi in rooms with little or no coverage in common areas of the hotel. Yes, I can hear some of you crying that being on holiday should …

Continue reading

Episodic Versus Seasonal Consumption

If there is one thing that technology has enabled in terms of content consumption it is the ability to consume content at a time that is suitable to you including the latest television series and movies. While you can view a series in the traditional method (i.e, one by one as they are released) it …

Continue reading

Using Your Television Remote with Raspbmc

After not tinkering with my Raspberry Pi for a little while I thought it was time to fire it up again and see what interesting things I could do with it. I thought it was a good idea to wipe it clean and put the latest version of Raspbmc on it. I would have let …

Continue reading

How to Shutdown Raspbmc Properly

I admit, I have been lazy in shutting down Raspbmc on my Raspberry Pi by just pulling the plug which has probably caused some of the problems with booting up the media centre software necessitating a fresh reinstall. Sure, the device doesn’t use that much power at all so I could probably leave it plugged …

Continue reading

Automatically Loading a Form in Microsoft Access

Here’s another quick tip for Microsoft Office – this time for Microsoft Access for you budding database experts. If you lock down your database and prevent users from navigating its objects then by default nothing will show up when the database is loaded. Similarly, if your users are using the Microsoft Access Runtime (a cutdown …

Continue reading

Incorporating Carriage Returns into Formulae in Excel Spreadsheets

Following on from yesterday’s tip on how to search for carriage returns in Excel spreadsheets, here’s how you can incorporate this non-printable character into your formulae. The secret sauce for carriage returns is to include CHAR(10) into your formulae. For instance, if you want to concatenate two cells but put the values on different lines in …

Continue reading

Searching For Carriage Returns and Tabs in Excel Spreadsheets

Most people know how to use the search and replace function in Excel spreadsheets but it can be a tricky task if what you’re looking for is a non-printable character like a carriage return (i.e. hitting Enter on the keyboard). Thankfully, it’s easy enough to do once you know how 🙂 In the Find and …

Continue reading