00. Intro (7:35)
Topics Covered
Pre-Requisites
01. Create Database (7:02)
Turn on Overlapping Windows
Create Database File
Create Calendar Table
Create Calendar Form
02. Appointment List 1 (13:56)
Form to List Appointments
ApptListF
Double-Click to Open Appt
OnDblClick Event
Show Closed Items Checkbox
03. Appointment List 2 (7:54)
Triple State Checkbox
Show Closed, Open, All Appts
Create Dynamic SQL Rowsource
Refresh Button
List.Requery
Change Form Caption in VBA
04. Monthly View Form 1 (11:39)
CalendarQ With Short Time
DatePickerF Enter a Date
Start Monthly Form
05. Monthly View Form 2 (10:23)
Day 2 of our Calendar Form
Text Boxes to Show Dates
Make 7 Boxes for the Week
06. Monthly View Form 3 (11:30)
Calendar Control
Calculate First Day of Month
First Sunday on or Before 1st
07. Monthly View Form 4 (10:51)
Grey Out Days of Diff Months
Forms!Form("FieldName") Notation
&HFFFFFF Color Notation
08. Monthly View Form 5 (10:26)
Shrink Text
Get Rid of Horizontal Scrollbars
DblClick Event to Open Appointments
Use Excel to Generate VBA Code
09. Calendar Report 1 (9:40)
Design Printable Monthly Report
10. Calendar Report 2 (12:14)
VBA Code Rewrite for Reports
Using the Detail Build Event
11. Review (3:39)