IN THIS PART
This part explains the art and science of Visual Basic for Applications (VBA) programming. Very few professional-quality Access applications have been written without liberal use of the VBA programming language and its capabilities. VBA provides you with powerful tools for adding capabilities and flexibility to your applications.
VBA is a fully qualified programming language and is used in many other Microsoft products, including all the main members of the Microsoft Office suite (Word, Excel, and PowerPoint), in addition to Microsoft Access.
Many user requirements simply cannot be implemented without using VBA code. VBA code provides functionality that goes far beyond simply opening forms and reports and controlling the user interface. You'll use VBA code to validate data, as well as transform and combine data in new and interesting ways. VBA code is used to import and export data, respond to user input, and handle the mistakes inevitably made by users.
VBA code enables you to seamlessly integrate with the other applications in Microsoft Office. For instance, using a surprisingly small amount of code, you can implement a very powerful mail-merge system by combining Access ...