Tag Archives: Information Worker

Data Access IS The Problem

Posted on October 26, 2011 by Biggus Dickus

I have harped on this here before, but once again my blood-pressure is rising because I have seen a simple, efficient use of the powers of Excel marginalized by a client’s inability to get support and cooperation from the “Gate-Keepers” … Continue reading →

Posted in Uncategorized | Tagged , , , , | 15 Comments

TEMPVARS Look Like The Secret In Access Services Web Forms

Posted on October 7, 2011 by Biggus Dickus

Anyone who comes here for Access stuff knows that I am a BIG fan of the Hybrid capability of Access 2010 with SharePoint 2010 and Access Services.  But I am getting dragged kicking and screaming into more Browser-only stuff as … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 23 Comments

PowerPivot CTP3 Hierarchies Make All The Difference

Posted on September 26, 2011 by Biggus Dickus

I have been around OLAP databases since 1994.  By “around” I mean that I have used them off and on for all those years without actually becoming a true BI dev – rather I am an occasional consumer. This is … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 3 Comments

Let’s Push Access Services

Posted on September 19, 2011 by Biggus Dickus

The last year and a half hits on my Blog have steadily increased (despite my postings steadily decreasing :-)).  There is a simple reason for this….  People are reaching out to find out about Access Services and yet, frankly, there doesn’t … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 10 Comments

What I Did This Summer

Posted on September 7, 2011 by Biggus Dickus

I have now returned home to Canada after an extended stay in the Netherlands over the summer working on an Access Services project.  Beyond the fact that there are much worse places to hang out than Holland, I also learned … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , | 4 Comments

Dutch Treat

Posted on July 13, 2011 by Biggus Dickus

Sorry for not blogging lately (as is if anyone actually comes here – actually quite a  few do). I have been busy, busy on a project in Europe while working evenings back in North America. I actually like this double-time … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , | 6 Comments

No Mention Of Excel Or Access … Hmmm …

Posted on June 9, 2011 by Biggus Dickus

I just saw an interesting article in the Seattle Times where they interviewed somebody named Kurt DelBene who is apparently the President of the Microsoft Business Division.  From the article (linked below) it seems that this guy DelBene is responsible … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , | 3 Comments

Dynamic Range Names And Charts In Excel 2010

Posted on May 19, 2011 by Biggus Dickus

(Update 05/27/11)  Please be advised that there is a more recent post than this that completely negates the need for the technology mentioned in this Post.  It does not mean this is not a Cool solution (IMHO) but it is … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , | 20 Comments

The Perfect Storm

Posted on April 27, 2011 by Biggus Dickus

For years I have been arguing that the combination of Excel and Access is the strongest “story” in Microsoft Office – and the most ignored.  I have used these two products together and separately to deliver solution after solution that … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 4 Comments

I Didn’t Follow My Own Rules

Posted on December 22, 2010 by Biggus Dickus

I am currently involved deeply in a project that replaces an exisiting spreadsheet-based production-planning system.  The existing user-maintained document is one of the most dangerous spreadsheets I have ever seen. But when contacted to help on this I made a terrible … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , | 5 Comments