File Dialog Save-As in VBA Export Table by Name | Microsoft Access

Sometimes it is necessary to export a table to create a backup, share data with a team member, or whatever… Here is how you export a table using the File Dialog object in Access with VBA. This example will work in Access 2007 – 2013. UPDATE 02/16/2015: Added reusable code for file save-as dialog box. […]

Set Appointment in Outlook With VBA in Access or Excel 2010, 2013

When writing automation for certain processes, it is sometimes important to set a follow-up reminder appointment for the next step. For this task, I wrote a very simple script that sets a reminder in Outlook. This script is super simple and can be improved several different ways. For simplicity sake, I decided to leave out […]

Calculate Date in Business Days in VBA Without Database Tables

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 […]

Crack Microsoft Excel Password Free | Excel 2007, 2010, 2013

protect-excel-document

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

Import Excel File into Access 2010, 2013 with VBA File Dialog

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, […]

Access 2010, 2013 VBA Run SQL Return Results

Sometimes when developing automation with VBA in Access, it is important to return results from a SQL query string. For simplicity, all examples have been written as Functions. Please feel free to modify as needed. Recordset Selection in VBA | Select One Record There are many reasons why a developer would want to return only […]

How to Display SQL Query Data with Listbox in Access 2010 with VBA

form-data

Sometimes I like to use the listbox control in Access to display information. Partially because I like the look of it and partially because it offers up a better user experience. You will note that the title references Access 2010 where my screenshots see were taken in 2013. I use 2010 on my work computer […]