Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA, Design and Advanced Methods Workshop 2
Section 1: Introduction and Overview
Introduction (3:29)
Section 2: Setting Subform Colors
Overview of Setting Subform Colors (7:37)
Setting Subform Colors with Access VBA (7:21)
Finish Placing Codes and Final Testing (5:19)
Section 3: Using Queries to Create Year Over Year Comparisons
Demonstration and Overview of the Objective (2:16)
Create the Query that Makes the SalesByQuarter Table (6:46)
Start Building the GetLastYear Query (9:20)
Add the Sales Difference to the GetLastYear Query (4:25)
Section 4: Create Running and Page Totals on Reports
Create Running and Page Totals (10:06)
Section 5: Set the Starting Autonumber in a Table
Set the Starting CustID and Append Customer Data (5:33)
Section 6: Back to Record on Open
Overview of the BackToRecord Database (2:28)
Open on Customer Form and Record Values on Exit (10:15)
Modify the Customer Open Subroutine to Use the Values in the Table (8:43)
Section 7: Design Challenge - The Security Company Call List
Overview of the Call List Design Challenge (11:47)
Add VBA Code to the Edit Button (11:14)
A Function to Test for No Records and Add VBA Code to the Add Button (11:15)
Create a Subroutine to Sort the Call List Records (5:01)
Add Code to the Delete Button (9:26)
Start Building Code for the Change To Combo Box (6:45)
Build the LostFocus Sub and Start the AfterUpdate Sub (5:45)
Figure Out How to Handle Change To Renumbering (3:39)
Create the Decrease Sequence Subroutine (6:45)
Create the Increase Sequence Subroutine (7:25)
Testing for Errors (8:45)
Final Testing and Debugging (8:08)
Section 8: Conclusion
Conclusion and Overview of What We Covered (2:07)
Teach online with
Start Building Code for the Change To Combo Box
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock