February 2013 archive

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

If You’re an Aussie on Travel Then Register with Smart Traveller

Just a quick tip which may come in handy when your access to technology may be limited when overseas compared to being at home. While letting friends and family know where you will be before you head out on holiday it also can’t hurt to register your details with Smart Traveller which will pass your detail …

Continue reading

Rdio – An Alternative to Spotify in Windows Phone 8

For the Windows Phone 8 faithful there have been some key applications missing that might help tip the scales in its favour. Big names such as Instagram are still noticeably absent despite a pledge late last year that an app would arrive. Spotify is very much in the same boat and its tardiness might be …

Continue reading

Clear the Safari Cache on iOS

Here’s a quick tip for iOS users if you need to clear the Safari browser cache in iOS. This can be handy if a website isn’t rendering properly or if you’re doing some web development and the cached page is stuck in your device. From the home screen: tap Settings, tap Safari, tap Clear Cookies and Data. Hit …

Continue reading

An Extreme Team Fortress 2 Experience

A lot of TF2 players out there would be used to the stock playing experience which has been the product of Valve carefully tweaking the traits of each class and weapons to maintain some sort of balance. However, you may want to experience something a little different. One of my favorite TF2 servers is TF2 EXTREME run …

Continue reading