This is a more complete version of the original article.
Continue reading →

APIs (Application Programming Interfaces) are used to access functions in external libraries such as DLLs, OCXs and LIBs. They are an extremely powerful tool that allows us to tap into programming power that VBA in itself cannot reach. The most widely used APIs are the Win32 APIs, allowing us to do things such as use the windows common controls and dialogs (Open/Save Files, Browse Folders, get Temp Paths and Temp File Names), interact with the Spooling (printing) system, and intercept and act upon messages that the operating system sends and receives (hooking).
Continue reading →

Access, like many RDBMS uses Structured Query Language (SQL) to define queries. Novice developers or casual users may have never seen a single SQL keyword when building queries. This is possible thanks to Access’ excellent graphical query builder. However, there are times when writing SQL may be desirable or in some cases, required.
Continue reading →