Microsoft Access 2010 Bible

Chapter 28: Object-Oriented Programming with VBA 973 You can, therefore, define new data types to accommodate whatever peculiari ...

Part IV: Professional Database Development 974 TABLE 28.2 Product Class Methods Used in the Example Database Name Purpose Sell S ...

Chapter 28: Object-Oriented Programming with VBA 975 FIGURE 28.1 You’ll use the name you provide for the class module as the obj ...

Part IV: Professional Database Development 976 Access treats each public variable in a class module as a property of the objects ...

Chapter 28: Object-Oriented Programming with VBA 977 Public Sub Sell(UnitsSold As Integer) Me.UnitsInStock = Me.UnitsInStock - U ...

Part IV: Professional Database Development 978 Eventually, with enough work and attention to detail, you can refine the product ...

Chapter 28: Object-Oriented Programming with VBA 979 Tip I prefer using separate statements for declaration and instantiation, b ...

Part IV: Professional Database Development 980 frmProductUnbound makes several property assignments from the form’s Load event p ...

Chapter 28: Object-Oriented Programming with VBA 981 Property errors might occur if the code passes a string when a numeric valu ...

Part IV: Professional Database Development 982 Encapsulating functionality The greatest benefit from using objects is encapsulat ...

Chapter 28: Object-Oriented Programming with VBA 983 The mix of properties (and their data types), methods (and the arguments ac ...

Part IV: Professional Database Development 984 FIGURE 28.6 The Auto List Members drop-down list makes it easy to select an objec ...

Chapter 28: Object-Oriented Programming with VBA 985 to object-oriented programming techniques because they want more control ov ...

Part IV: Professional Database Development 986 Using Property Procedures The concept of property procedures is fundamental to ob ...

Chapter 28: Object-Oriented Programming with VBA 987 FIGURE 28.8 Each time you read or write an object’s properties, the class m ...

Part IV: Professional Database Development 988 Property Let The Property Let procedure assigns a value to a property. The proper ...

Chapter 28: Object-Oriented Programming with VBA 989 Property Get This is the basic syntax of the Property Get: Public Property ...

Part IV: Professional Database Development 990 In a VBA project, property-value persistence is mediated through private variable ...

Chapter 28: Object-Oriented Programming with VBA 991 Definitions of property procedures for the same property are inconsistent, ...

Part IV: Professional Database Development 992 FIGURE 28.10 The Products_OOP form demonstrates unbound object-oriented technique ...