Recently, I was working on a side project that did some cool things with business days. In one of the use cases, I needed to figure out the date five business days from the current date. My solution needed to be built for technical staff to easily modify exclusion dates. My solution also had to be something that could be set once and forgotten as the end-user pool is expected … [Read more...] about Calculate Business Days in VBA Without Table
MS Access
Reset Autonumber Field in Access Without Recreating Table
This is going to be a very short and sweet (and saweeeet!!! that you don't have to delete) post. Have you ever wanted to reset the counter on a autonumber field in Access, but don't want to delete the table and start over again? SQL Magic to the rescue! Before running the SQL statement below, you should understand that by re-numbering an index, you will lose access to data in … [Read more...] about Reset Autonumber Field in Access Without Recreating Table
Automatic Mail Merge With VBA and Access
I once built a program with MS Access that handled a mail merge job of ~1000 letters per week. It used a very simple word template. For input, every Friday, I pulled data from a production SQL database which I saved to an Excel spreadsheet. I built an import function that loaded the Excel data into table in my MS Access tool. The program ran a mail merge process for all … [Read more...] about Automatic Mail Merge With VBA and Access
SOLVED: Late Binding File Dialog in VBA Example
I have been trying to figure out a solution to late binding the file dialog object for a long time. I have played with the code, googled for examples and haven't had much luck until today when a generous visitor of ours posted the solution in the comments of our Select or Open a file in VBA with file dialog post. The original FileDialog post referenced above shows an example … [Read more...] about SOLVED: Late Binding File Dialog in VBA Example
Import Multiple Spreadsheets into Access | File Dialog VBA
Sometimes it would be great to combine a bunch of spreadsheets into one table. When working with consolidated spreadsheet data, be sure to manage duplicates. To import multiple spreadsheets into Access with VBA, there are a few housekeeping items that must be completed. First, you need to make sure that the data structure for all of your source files is the same. Field names, … [Read more...] about Import Multiple Spreadsheets into Access | File Dialog VBA