Access Developer 15. Introduction

Lesson 1: Move Between List Boxes (20:15)
Active / Inactive Customer List Boxes
Move Between Boxes
UPDATE SQL Statement
Docmd.RunSQL
SetWarnings
Passing a Control as a Parameter
Control.Name
Control.Value

Lesson 2: Debugging Level 2 (31:55)
On Error Resume Next
Invalid Use of Null
Debug Toolbar
On Error Goto 0
On Error Goto MyErr
Err.Description
Custom Error Messages
Exit Sub Before Error Handler
Immediate Window
Show Debug.Print
Immediate Window
Basic Math ?5+9
Checking Variables ?X
Set a Breakpoint
Testing Function Return Values
Test a DLookup
I prefer StatusBox for Users to See
Status Function
Step Over, Step Into, Step Out
Watch Window
If DEBUGMODE
Global Const

Lesson 3: Multi-Select List Boxes (42:34)
Change to Multi Select
Simple v. Extended
.ListCount Property
.ItemData(Row) Property
Don't Use Column Headers
Loop Through All Items
For X=0 to Count-1 (For Loop)
With / End With (Dev 11)
.Column(0,x) Property - Row is New!
How to Tell What is Selected
.Selected(Row) Property
Status Selected Items Only
For Each Loop
For Each I in .ItemsSelected
Control variable must be Variant or Object
ChangeCustomerStatus Update
Call ChangeCustomerStatus in Loop
For Each Form in Forms Collection
Write ButtonCode Sub
Change IsActive to IIF Function
CTRL-Y to Delete a Line
db.Execute vs. DoCmd.RunSQL
Select All / Deselect All buttons