Visual Basic for Applications articles
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 to instead use vba to create the spreadsheet and place the values of each column and row into each ce [...]
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 introduced starting in Access 2007 and represented a major addition to the arsenal of tools for profe [...]
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 on the fly and then pass it along to the default browser on your PC. Note: for the same technique usi [...]
Map route on Google Maps with Addresses in Access
Google 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 on the fly and then pass it along to the default browser on your PC. Here's the code: Private Sub cm [...]
Access function to return day of the week
Sometimes you need the actual day name of the date and not the numeric equivalent, the following function will do that for you: Public Function MyWeekDayName(dteDate As Date) As String 'Will return "Monday", "Tuesday", etc. based on the date supplied MyWeekDayName = WeekdayName(WeekDay(dteDate), Fal [...]