This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
4 Hour VBA Course
Introduction
Course Overview (2:53)
Section 1: The MACROS Object
Create an Autoexec Macro (4:35)
A Macro to Close the Database (11:57)
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
Next Steps (1:49)
An Example of the Power of SQL in VBA
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock