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 …
February 2013 archive
Feb 06 2013
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 …
Feb 05 2013
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 …
Feb 04 2013
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 …
Feb 03 2013
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 …
Feb 02 2013
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 …
Feb 01 2013
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 …
Follow Us!