Category Archives: Access

Tech Support Call From 1985

I received THIS request for tech support YESTERDAY … Hi Dick, Would you please tell me what a Code A is and how we fix it. When we try to add soy loads to one of the years we get … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, VBA | Leave a comment

This post is about the Windows 10 Start Menu Corruption BS ….

I am going to talk about something that most users of Windows 10 have not run into yet, so most will probably be inclined to just write this post off as irrelevant to them .. Just wait !! This post … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, the Cloud, Windows 10, Windows 10 Start Menu | 6 Comments

My Rules For Solution Engagements …

I’m baaaack … again … I have decided that I just cannot not blog … I have too many thoughts and I sure would hate to see all the knowledge I have accumulated disappear with me into retirement someday (or … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, VBA | 3 Comments

My Thoughts On Excel TV

Earlier this week I appeared on the Excel TV broadcast with Rick Grantham, Jordan Goldmeier and Oz du Soleil …  It was great fun for sure and I hope it was somewhat valuable to the broad Excel community (and even … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 8 Comments

Changes In Procurement Practices Are The Death Of Us All …

Just replied to someone on LinkedIn in a  conversation about Access work getting really thin lately …  Thought my response might be a good blog .. (additions in blue) .. Jeff asked …”Has the market shifted to hiring contract programmers? … Continue reading

Posted in Access, Access Solutions, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, the Cloud, VBA | 2 Comments

Windows 10 – To Infinity and Beyond !!!

As I discussed here earlier the following has been officially announced by the MSM: http://www.bbc.com/news/technology-32658340 There are all kinds of implications of this – and one of them is NOT the death of Windows … quite the contrary.  Even if … Continue reading

Posted in Access, Access Solutions, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, Spreadsheets, the Cloud, VBA | 5 Comments

Access In The Cloud – Forever?

OK – here goes … 1. Have you and your business used Microsoft Access to help run your business for years ? 2. Are you pretty much completely happy with this Access solution and have invested a great amount of … Continue reading

Posted in Access, Access Solutions, Cloud, Microsoft Access, Microsoft Access 2013, Office 2013, Office Automation, Process Automation, Spreadsheets, VBA | 5 Comments

Microsoft Says What They Really Think

Thanx to Debra over at Contextures for letting me know about this presentation from the Office 365 Garage Series: http://blog.contextures.com/archives/2014/07/28/excel-roundup-20140728/ What we’re seeing here is an open statement by Microsoft that full-featured client Office is dead and that we must all … Continue reading

Posted in Access, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Spreadsheets, VBA | 16 Comments

The Microsoft Rapture

Read this link before reading my comments here: http://www.geekwire.com/2014/internal-memo-microsoft-cut-external-staff-18-months-requiring-six-month-break/ I believe that this (even more than the 18000 announced last week – most of whom are at Nokia) will force a HUGE reorg of Microsoft before the end of 2014 … Continue reading

Posted in Access, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft "V-", Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, Uncategorized, V-, VBA | 4 Comments

Data Access Is STILL The Problem

Below is a replay of a posting I made here waaaay back in 2011.  It discusses an issue that is not only STILL a problem for people trying to help businesses analyze their data but that is now exponentially worse … Continue reading

Posted in Access, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, VBA | 6 Comments