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