In a recent project, I had to build a program to calculate an end date in either business days or calendar days based on certain criteria. This solution had to work in both Excel and Access and needed to run without the use of database tables. Business Day Calculation Requirements The criteria I used to […]
Why Don’t My Columns Add in Excel?
There are many ways an end user can run into this problem. One of the most common causes that I have seen is when pasting data. Enter the Datatype Sometimes when data is pasted, no matter if it is in a number format from the original source – it can be pasted as text or […]
How to Count by Item With SQL | Group By Query MS Access
I also wasn’t sure how to word the title, but it seems to make sense. This is a very short post as this is pretty simple. When reporting out on data, there is the possibility that at some point, a report request will call for a count of items by group. I wanted to make […]
Crack Microsoft Excel Password Free | Excel 2007, 2010, 2013
It is always annoying when forgetting passwords. It is also annoying when you inherit a document from a previous employee and it is protected by a password only they knew. But your boss asked for you to get the data from that spreadsheet and change some things and Right now! What are you going to […]
Import Excel File to Access 2010, 2013 With File Dialog in VBA
I have been working with a lot of excel spreadsheets lately. In most cases, I have found that the most simple approach has been to load spreadsheets into Access tables and slice/dice data with SQL queries. I have one spreadsheet in particular that is standardized and updated daily. By quickly loading and running saved queries, […]