Microsoft Access 2010 Bible

Chapter 28: Object-Oriented Programming with VBA 993 Looking at the new ProductID property The ProductID property enhancement is ...

Part IV: Professional Database Development 994 m_ReorderLevel = -1 m_Discontinued = False ‘Also assign default value to ProductI ...

Chapter 28: Object-Oriented Programming with VBA 995 Public Property Get SupplierName() As String Dim varTemp As Variant If m_Su ...

Part IV: Professional Database Development 996 strSQL = _ “UPDATE Products SET “ _ & “ProductName = ‘“ & m_ProductName & ...

Chapter 28: Object-Oriented Programming with VBA 997 Learning about Class Events There are two very important built-in events th ...

Part IV: Professional Database Development 998 FIGURE 28.11 The Class_Initialize event procedure runs whenever an object is inst ...

Chapter 28: Object-Oriented Programming with VBA 999 FIGURE 28.12 The Class_Terminate event procedure passes control back to the ...

Part IV: Professional Database Development 1000 Learning about events in Access Events are a bit more complex than properties or ...

Chapter 28: Object-Oriented Programming with VBA 1001 set through the SupplierID Property Let procedure. The If...End If at the ...

Part IV: Professional Database Development 1002 FIGURE 28.13 The InvalidSupplierID event appears in the Object Browser. You’ll n ...

Chapter 28: Object-Oriented Programming with VBA 1003 RaiseEvent InvalidSupplierID() End If End Property The SupplierName proper ...

Part IV: Professional Database Development 1004 FIGURE 28.14 The WithEvents keyword instructs VBA to watch for events raised fro ...

Chapter 28: Object-Oriented Programming with VBA 1005 The RaiseEvent statement includes a value for the event argument: RaiseEve ...

Part IV: Professional Database Development 1006 Here’s all the code behind this simple dialog box: Public Event FormClosing(Mess ...

Chapter 28: Object-Oriented Programming with VBA 1007 Private WithEvents frm As Form_frmDialogForm Private Sub cmdOpenDialogForm ...

Part IV: Professional Database Development 1008 Note This technique eliminates the infamous bang-dot notation that Access develo ...

1009 CHAPTER Customizing Access Ribbons IN THIS CHAPTER Learning about the new Access ribbon Working with the default ribbon Exa ...

Part IV: Professional Database Development 1010 Unlike toolbars and menus in older Access versions, Access 2007 and 2010 support ...

Chapter 29: Customizing Access Ribbons ................................................................................. 1011 us ...

Part IV: Professional Database Development 1012 FIGURE 29.3 The Office ribbon resizes controls to accommodate the width of the A ...