1. Recordset to External Database (25:04)
Set up Back End Database
Connect with OpenDatabase
Set Database Password on Backend
Open Exclusive
Encrypt With Password
Send Password in Connect String
2. Add Followups (16:39)
GoToRecord
5, 10, 30, 90 Day Followups
3. Add Records GoToRecord (17:02)
Custom Boxes
Determine Next Box Number
DMAX Function
Split Prefix / Suffix
Nested FOR Loops
ASCII Codes, CHR Function
4. Add With RecordSets (15:59)
Much Faster!
Jump Back X Rows
Me.Recordset.Requery
5. TreeView Control 1 (27:24)
TreeView Control
Loading Nodes
Clearing the Tree
Showing Root Node Lines
Indentation, Font
6. TreeView Control 2 (35:07)
Expand, Collapse All
Employee Form
Supervisor Combo
Can't Be Your Own Supervisor
Employee Subform
Show Selected Employee