00. Intro (11:41)

01. Number of Work Days 1 (20:19)
Excel NETWORKDAYS Function
Create a Module
Reference to Microsoft Excel 15.0 Object Library
Create myNetWorkDays Function
Excel.Application
Remove the Excel Reference and Code

02. Number of Work Days 2 (21:05)
While Loop Date Counter
Count Number of Days Between Dates
WeekDay Function to Determine Day of Week
Holiday Exclusion Table
DLOOKUP to Check Holiday Dates
Dealing with #Error problem

03. Number of Work Days 3 (22:20)
Using DCOUNT Outside Loop for Speed
Validation Rule to Prevent Sat Sun in Table
IsWorkDay Function to Check One Date

04. Timestamp on Edited Records (16:40)
When was Customer Record Last Updated
Create Customer Table and Form
Use Default Value to Track Creation Date
Record Change to a Single Field
Record Changes to Multiple Fields
Field AfterUpdate Event
Record Changes to Entire Record on Form
Form OnDirty Event
Tracking Changes at the Table Level
Table Data Macros
Create Data Macro
Before Change Event
SetField Command

05. Reminder Popup Notifications 1 (27:32)
Create Reminder List Table
Reminder Text, ReminderDateTime, Closed
DLOOKUP to Check for Reminders
Closed=FALSE and Reminder Now or in Past
Conditional Formatting to Highlight Due Reminders
Checking for Reminders Automatically
OnTimer Event
Timer Interval Milliseconds
Constant MAXVAL
Countdown Loop for Timer
IsPaused Checkbox

06. Reminder Popup Notifications 2 (22:57)
Open Reminder Form if there are Reminders
Special Popup Reminder Form
Preventing the Popup from Interfering with Typing
Screen.ActiveForm
SetFocus Method
Set TimerInterval to Zero to Disable
You have 3 Reminders
DCOUNT to Count Number of Reminders
Label.Caption Property
Button to Show Reminder Form
Check to see if Reminder Popup Form is Open
CurrentProject
AllForms
IsLoaded Property

07. Reminder Popup Notifications 3 (29:41)
Remind Me Later Button
Remind Me in X Minutes
Access Commands Not Available Bug!
Have the Timer Pause Itself if On Reminder Form
OnActivate Event
Have the Timer Restart When Leave Form
OnDeactivate Event
Prevent User from Closing Reminder Form
Close Button Property
Buttons to Move Reminders +5 min, +1 hour, +1 day
Move Reminder to Tomorrow at 9am
Docmd.GotoControl to Move to Next Record
Hide Closed Reminders

08. How Many X Days in Interval (32:00)
How many Mondays are in This Month
Combo Box with Weekdays
Separate Month, Day, Year Values
DateSerial Function to Build Dates
First Day of Month
Last Day of Month
Loop Through Days
Code Breakpoints
CLng Convert Text to Long Int
Convert Code to a Function
Specify our own Interval (month, quarter, year)
How Many Tuesdays This Year
How Many Fridays This Quarter
Select Case Statement
Count from Target Date until End of Period

09. Calculating Holidays (34:33)
United States Holidays
Independence Day - July 4th
Christmas Day - Dec 25th
Labor Day - 1st Mon Sept
Memorial Day - Last Mon May
MLK Day - 3rd Mon Jan
Presidents Day - 3rd Mon Feb
Thanksgiving - 4th Thur Nov
Daylight Saving Time Begin - 2nd Sun Mar
Daylight Saving Time End - 1st Sun Nov
Veterans Day - Nov 11, +/- 1 day
Easter Sunday - Complex Calculation

10. Recurring Appointments 1 (47:09)
Add Frequency and Recurring to Reminder Table
Days, Weeks, Months, Years
Last Completed Date
Done Button
Move Recurring Appointments Ahead
Close Non-Recurring Appointments
Filter List of Appointments by Dates
Custom SQL Recordsource
Add Where Conditions
Show Closed, Open, Both
AfterUpdate Event

11. Recurring Appointments 2 (15:33)
Add Custom Sort Order
Custom Date Range Buttons
Back and Forward One Week's Appointments
See All Appointments Not Closed

12. Ordinal Dates (3:47)
MyOrdinal Function
Display 1st, 2nd, 3rd, 4th, etc.

13. Review (6:59)