01. Append Only 1 (17:10)
What is the Append Only property
Why you shouldn't use it
Better alternatives
02. Append Only 2 (34:24)
Recordset loop customers with notes
Use Application.ColumnHistory to get data
Parse string record by record
Save in Contacts table
SQL Insert Into Command
Removing CHR 13
03. TempVars Part 1 (19:22)
What are TempVars
Why Use TempVars
How to Use TempVars
Pros & Cons of TempVars
04. TempVars Part 2 (18:48)
Set a TempVar in VBA
Get a TempVar in VBA
Errors Clear Global Variables
Use .Value to Read From Textbox
Use in Form Field Control Source
Use in Default Value
Use in Caption with Code
Use in Query Criteria with !
05. TempVars Part 3 (22:04)
Different Ways to Add TempVars
TempVars.Add
TempVars.Remove
TempVars.RemoveAll
Check to See if TempVar is Set
Listing All TempVars, For Loop
Listing All TempVars, For Each Loop
VarType Function to Get Data Type
IsDate & Related Functions