Visual Basic for Applications articles
Self-healing Objects
Use self-healing objects to avoid problems with objects not being initialized when running your code.
Use temp tables in your code for quick and easy analysis
Learn to use temp tables in your Access code.
Dynamically sorting forms and reports
Learn how to order forms and reports dynamically using the open event.
Importing Outlook emails into Access
Article describes how to import Outlook emails into Microsoft Access using code.
Use Batch Transactions with SQL Server to Guarantee Results
Batch transactions are a great way to avoid orphan records and to guarantee the database has performed all of the actions you have requested. This post will discuss how you can incorporate batch trans [...]
Using IIF examples and tips
IIF can be used in a wide range of situations: when building complex strings or invoking commands.
Great article on using Excel object model
Recently I had to create an Excel spreadsheet export for one of my clients using my Report Generator in Access, it was a thorny project since it wasn't a straight export from a query or table. I had t [...]
Custom OpenForm code – Close and open your form
One of the major issues with DoCmd.OpenForm is it doesn't close the form before opening it again. This can lead to unexpected behavior of your application, so of course I created my own open form code:
Maximize the use of TempVars in Access 2007 and 2010
The TempVars collection has the ability to save developers time, improve the reliability of your programming and provide you with new ways to share information across your application. TempVars were i [...]
Map route on Yahoo Maps with Addresses in Access
Yahoo maps is great at mapping out a route you entered through the browser, but what if you need to map the addresses using a pre-defined route in Access? This tip will show you how to build the URL o [...]
