Screenshot of sample Access database

Exporting Access tables to Excel

There are pre-built Access functions to export data to Excel, such as the DoCmd.TransferSpreadsheet or DoCmd.OutputTo method, but anything but the most basic reports will require you to customise the Excel output more than these functions will allow. This code shows you how to create an instance of Excel and export the contents of the table into a […]

Example of the popup calendar when used in a spreadsheet.

Excel VBA Popup Calendar

Example of the popup calendar when used inline on a spreadsheet. The VBA editor does not have a calendar control available to it by default – however it is possible to use the MS Access calendar control.  This tutorial is on how to set up a calendar control that can be accessed via a UserForm, […]