Introduction
Section 1: The MACROS Object
Section 2: Intro to VBA
-
Create and Test a Module Function (12:26)
-
Call from Another Program (9:33)
-
Return a Value and Analyze the One Line Function (8:04)
-
Fixing the Program and Handling Errors (9:04)
-
Building Tools: MyYesNoBox (5:18)
-
MyYesNoBox Part 2 - Tempvars, Comments, Dialog (10:06)
-
MyYesNoBox Part 3 - Open Subroutine, ME Keyword, NZ Function (9:32)
-
MyYesNoBox Part 4 - Setfocus, Keydown and Select Case (8:30)
-
MyYesNoBox Part 5 - KeyCodes and Intro to Stops (10:04)
-
Openargs, Calling Subs and Eliminating Duplicate Code (5:39)
-
Debugging Examples (7:46)
Section 3: Add VBA to Existing Forms
-
Create New Orders Table and Form, Change CustID to Combo Box (10:11)
-
BeforeUpdate and AfterUpdate (10:41)
-
Use SQL to Update Last Name in Customer Table (11:14)
-
An Example of the Power of SQL in VBA (2:28)
-
Add MyYesNoBox and Make a Generic Update Subroutine (10:02)
-
Add a Button to Return to the Customer Form (9:48)
-
Add Buttons to go to the Customer Orders Subform (8:05)
-
Create a Products Subform (9:29)
-
Create Code to Update the Order Total (10:22)
-
Create Invoice Part 1 - Make the Invoice Table (9:08)
-
Create Invoice Part 2 - Add Order Data to Invoice Table (5:57)
-
Create Invoice Part 3 - Add Product Number and Totals (10:27)
-
Create Invoice Part 4 - Create the Invoice Report (11:25)
Conclusion
