1. ByRef v ByVal Part 1 (11:57)
Passing Values
Learning the Difference
Example: Increment Sub
2. ByRef v ByVal Part 2 (11:58)
Optional Parameters
Use with Form Controls
Determine if Field or Number
Public Subs & Functions
3. ByRef v ByVal Part 3 (18:36)
Function that Returns Multiple Values
Return a Status Code
Return Customer Name
4. Active Form & Control (16:51)
Screen.ActiveForm
Screen.ActiveControl
Screen.PreviousControl
Dim F As Control
Set Keyword for Objects
List of Control Types
acTextBox Type
Change Properties Like BackColor
5. Product Groups 1 (30:09)
Product Group Table, Form
Product Details Table, Form
Calculate Bundle Price
6. Product Groups 2 (37:47)
Add Package as Line Item
Loop Through Package Details, Add
Hide $0 Prices On Invoice in Detail Section
Indent $0 Line Items
Bold Package Names