I am writing this one as part two of my post: How to Connect to Access Database with VBScript As part of building the above example, I kept experiencing this error. I found out that 64 bit Windows 7 and Windows Vista don’t have the ability to run VBA in 64 bit. You have to […]
How to Connect to Access Database with VBScript
I am posting this one because it took me a little while to find a solid solution. Everything I found had an answer, just not an answer that works. With this solution, you will be able to connect to and pull data from an MS Access database with VBScript. So without further ado, here is […]
Simple Mortgage Calculator Function | Excel, Access VBA
There are a lot of ways to calculate a mortgage payment in Excel. I honestly haven’t made any attempts to calculate a mortgage payment in Access using standard functions. There has to be a way, but for fun, I thought that I would share a simple function. To use this function, insert it into a […]
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 […]