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

VBA Explained

VBA is the development language for Microsoft Access 2003. 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 2003, Microsoft Visual Basic 6.0 and earlier, Microsoft Excel, Microsoft Word, Microsoft Outlook (for application-wide programming), and Microsoft Project. What differs among these environments are the built-in objects specific to each application. For example, Access has a CurrentProject object, but Excel has a Workbook object. Each application's objects have appropriate properties (attributes) and methods (actions)—and, in some cases, events—associated with them. This chapter gives you an overview of the VBA language and its constructs.

Unlike macros in Word or Excel, Access macros are not subprocedures in modules; instead, they are a different type of database object, with their own interface. Because of this, you can't use Access macros to learn to program in VBA, as you can by recording a Word or Excel macro and then examining its VBA code. You can write simple Access applications by using macros. Although macros are okay for quick prototyping and very basic application development, you will do most serious Access development 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