• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

VBA Explained

Visual Basic for Applications (VBA) is the development language for Microsoft Access 97. It offers a consistent language for application development in the Microsoft Office suite. The core language, its constructs, and the environment are the same in Microsoft Access 97, Microsoft Visual Basic, Microsoft Excel, Microsoft Word, and Microsoft Project. What's different among these environments are the built-in objects specific to each application. For example, Access has a Recordset object, but Excel has a Workbook object. Each application's objects have appropriate properties (attributes) and methods (actions) associated with them. This chapter gives you an overview of the VBA language and its constructs.

Simple Access applications can be written by using macros, covered in Chapter 11, “What Are Macros and When Do You Need Them?” Although macros are great for quick prototyping and very basic application development, most serious Access development is done by using the VBA language. Unlike macros, VBA gives you the ability to do the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint