Unfortunately, in some states (Arkansas, Hawaii, Idaho, Massachusetts, Montana, North Dakota, New Hampshire, South Carolina, and South Dakota) only a small number of reporters responded to our survey. Hence while interpreting the results from these states we should be cautious.
(March 2013) Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was discontinued in 2008, and its associated integrated development environment (IDE).
Once again VBA comes to the rescue. If Access doesn't have the function you need, you could try writing one of your own. This tutorial shows you how to build and use a custom function and shows you how to use it in forms and queries. You will often see custom functions referred to as UDFs (User-Defined Functions).