Wednesday, September 28, 2011

Making History by Doug Den Hoed

Doug Den Hoed is back with another new technology invention. This time, he introduces his technique to capture multiple on demand history time slices of an application, allowing you to instantly flip back in time and view data from  back then. 

Saturday, September 24, 2011

Matching Data for Analysis

In this article, Rickard Olsson shows how to compare rows in SQL by loading the desired data into two tables for easy comparison. In fact, he shows two different methods and tries to figure out which method will give the best performance.  Read the pdf article

Microsoft Access Forms—All Class

If object-oriented development seems foreign to you, it shouldn't. All forms are defined in class modules, and all executing forms are objects. Garry Robinson shows how to take advantage of this to create classy forms.

Read Garrys article here

Saturday, September 17, 2011

Have I Thrown In the Towel

A user asked this great question

I’ve been in MS Office dev for quite a while…Access, Excel, Outlook….
Still, I learned a lot from your website. 
That being said, I saw nothing about Access 2010.

Have you “thrown in the towel” and stopped working in Access ? 
There’s very little work in the USA in Access right now.  That’s why I ask.

My reply..
First I havent posted much on Access 2010 for a number of reasons but the principle one is that I am still working through the backlog of Smart Access articles and posting them to  There are a few hundred online now.  I keep thinking about cute little things that I have learnt about Access 2010 and 2007 but when I compare that to putting all those well editied and thoughtout articles in the Smart Access collection, I just go back to reformatting and indexing Smart Access, its far more worthwhile for everyone.

As for work, I have had quite a few really interesting projects in Access in the last few months. Australia, thanks to the Chinese led mining boom is still pretty busy though there are signs that things are slowing.  My work collegues and I are good at mining and manufacting software so we still seem to be kicking goals for now.  Access still seems to come up trumps as a clean and powerful interface that works well with Office (read Excel) documents.

If I had to hazard a guess as to why Access has disappeared off the radar for this reader, its probably because external Office programming projects are probably one of the easiest for IT departments to dump to save money. That seemed to be the case for us in 2009 when things fell off the cliff.  Our work dropped to 25% in two weeks. My recommendation when work drys up is work harder than you have ever worked before at getting the work back. Don't take a break until the big break comes along.  Try everything to market yourself well and learn as much as you can about the things that improve your prospects.

Monday, September 12, 2011

Optional parameters in SQL Server stored procedures

Russell Sinclair talks about optional parameters in SQL Server stored procedures, and how you can use them to do advanced searching of data. Read article

Thursday, September 08, 2011

Access Developer Needs a Date

Doug Steele looks at problems with handling dates - like inputting regional dates and guiding you to the reliable VBA date functions  Read the article here

Wednesday, September 07, 2011

Ribbon Vs Apple - A study of the UI

If you have a beef about the ribbon and think "I wonder if the mac is truly easier", this article gives a decent side by side comparision of the photo editing tools in both environments. Its actually a good way of comparing the old drop down menus verses the ribbon. I think the other standout difference between macs and windows is right click context sensitive menus verses Nothing [Where is the right click button on a Mac?]