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 force it to use the 32 bit driver. Have you ever encountered: Error: Provider cannot be found. It may … [Read more...] about SOLVED: Provider cannot be found. It may not be properly installed
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 the example: Access Source Data For this example, I am using a database stored in a folder … [Read more...] about How to Connect to Access Database with VBScript
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 module. For Excel, make sure you save your Excel document as a "Macro-Enabled" w … [Read more...] about Simple Mortgage Calculator Function | Excel, Access VBA
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. Create a new module or add the following code to an existing … [Read more...] about File Dialog Save-As in VBA Export Table by Name | Microsoft Access
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 the fancy "With" procedure and just use the object … [Read more...] about Set Appointment in Outlook With VBA in Access or Excel 2010, 2013