Visual Basic for Applications articles
Global variables are a wonderful way to make your code consistent, powerful and easy to use, but the native Access global variable, one declared in a stand alone module has a critical flaw: it will reset if there is a problem in your code, and it does not retain it's value once you close Access. Use [...]
IIF can be used in a wide range of situations: when building complex strings or invoking commands.
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 [...]
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:
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 [...]
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 [...]
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 [...]
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 [...]
