01. Event Countdown 1 (54:15)
Create Event Table, Query
Calculate Days Left to Event
Event Edit Form
Buttons to Edit, Add, Delete Events
Conditional Formatting Close Events
02. Event Countdown 2 (28:30)
Custom Color Schemes
Change Color Per Event
Conditional Formatting Based on ID Value
03. Custom Color Editor (21:25)
Color Form
Text Fore Color, Back Color
Number Fore Color, Back Color
Choose Color Dialog
Windows Color Picker
HexToRGB, RGBToHex
04. Conditional Formatting VBA 1 (24:16)
FormatCondition Object
FormatConditions Collection
FormatConditions.Delete, .Add
Determine Max Conditional Formatting Items
Count Records in Current Form
Me.Form.Recordset.RecordCount
05. Conditional Formatting VBA 2 (16:51)
Add Additional Controls
Open Form to the Right of Current Form
OpenFormRight Sub from Code Vault
Refresh Events from Color Form
Update ColorPicker, RGB/Hex Functions
06. User Defined Types(10:57)
What is a User Defined Type in VBA
Public Type Definition
Passing a Type Variable ByRef
07. Windows Font Dialog (30:36)
Changing Fonts at Runtime
FormFontInfo Type
User Selecting a Font
Selecting Fonts for Event Form
Saving, Loading in Settings Table
Passing a Control to a Sub
08. Custom Font in a Report (11:46)
Simplified Letter Writer
Setting Font in a Report
Saving Font Setting in Each Letter
Report Font Issues