Section 1: Introduction
Section 2: Start Learning VBA and Handling Errors
-
View Database Table and Forms - Review the Goal (1:51)
-
Create Your First VBA Subroutine! (7:41)
-
Fix a Syntax Error and Take Over the Keyboard (3:24)
-
Use an IF Statement and DoCmd (4:28)
-
Use ElseIf and a Select Statement (6:13)
-
Runtime Errors, Error Traps and Program Stops (9:59)
-
Break Into Programs and Infinite Loops (3:48)
-
Section 2 Conclusion and Review (4:05)
Section 3: Create Record Sorting Subroutines
Section 4: Use Instant Search to Learn More About the Keyboard, Recordsets and Variables
Section 5: Interact with Other Forms and Pass Information
-
Open Another Form with a Button Click (6:16)
-
Send Data to the Other Form (4:15)
-
Modify a Form to Utilize Data Sent to it (6:06)
-
Intro to SQL and Using SQL in the Recordsource (7:09)
-
Locate Same Record When Returning from the Form (5:27)
-
Modify the Form to Remember the Sort (6:34)
-
Create a Prompt to Save Changes (4:50)
-
Activate the Add Customer Button (4:30)
-
Testing for a Blank Record (9:54)
-
Activate the Delete Button (6:02)
-
Section 5 Conclusion and Review (2:31)
Section 6: Add Multiple Interactive Pulldown Filters
-
Setup Rowsource for Dropdown Filters (8:29)
-
Enable Editing in the Dropdown Filters (7:49)
-
Set Dropdown Rowsources on the Fly (8:25)
-
Create a Subroutine to Build All the Filters (7:35)
-
Use the AfterUpdate Event to Rebuild the Filter (3:29)
-
Setup the Clear Filter Buttons (4:43)
-
Save the Filters when Closing the Form (8:30)
-
Section 6 Conclusion and Review (3:02)
Section 7: Build a Report Containing Complex Calculations
-
Inspect the Tables and Review the Goal (3:00)
-
Creating a Summary Table with a Query (6:44)
-
Building Our First Function and Saving Queries to VBA (6:16)
-
Add a Delete Query and Create a Test Macro (4:30)
-
Restructure Tables and Add a Second Query to Our VBA Function (6:24)
-
Figure Out How to Get the Days Between Orders (6:06)
-
Doing the Steps with a Recordset (10:05)
-
Calculate the Average Days Between Orders (7:04)
-
Plug the Average Days into the Report Table (10:39)
-
Section 7 Conclusion and Review (2:45)
Section 8: Turn Off the Menu, Ribbon and Navigation Pane
-
View the Example of Removing the Nav Pane and Ribbon (1:39)
-
Create the HideMenu Subroutine (7:16)
-
Call the HideMenu Subroutine from our Form (4:15)
-
Make the Subroutine Toggle the Menus (4:54)
-
Create a Startup Subroutine and an Autoexec Macro (4:38)
-
Prevent Closing the Form and Activate the Exit Button (5:54)
-
Section 8 Conclusion and Review (2:02)
Section 9: How to Create and Modify Table Structures in VBA
-
Overview and Goal (1:57)
-
Create Delete Subroutine and Make First Changes to SummRpt Function (2:57)
-
Backup the SummRpt Function and Make the First Changes (2:55)
-
Pull a Query from VBA Back to Design, Change It and Update VBA (4:44)
-
Use TableDefs to Add a Field to a Table (4:50)
-
Use TableDefs to Create a Table and Add Fields to it (4:21)
-
Make Final Changes and Test the Modified Function (2:50)
Section 10: USING VBA with SUBFORMS
-
Overview of the Tables in the Subforms Database (3:14)
-
Overview of the Forms in the Subforms Database (2:18)
-
Add OrderList as a Subform to the Customer Form (6:38)
-
Using an On Exit Subroutine to Capture the Order Number You Were On (4:47)
-
Pass the Order Number to the Go To Order Button (4:37)
-
Open the Orders Form and Move to the Specified Order (5:22)
-
Create Code to Return to the Customer Form (5:32)
-
Setup the OrdProdList Subform (4:51)
-
Create a Total in the Subform (4:24)
-
Update the Subtotal and Order Total (4:20)
-
Add a New Product to the Order (5:00)
-
Create the Add Order Subroutine and Post a New Order (9:51)
-
Get the New Order Number and Open the Order Form (4:48)
-
Review, Conclusion and Future Enhancements (2:59)
Section 11: Using POPUP Forms
-
Import Customer List Form and Rename it as CustPopup (3:00)
-
Prepare the CustPopup Form for Use as a Popup Form (4:58)
-
Modify the Customer Form Code to Open the Popup (5:03)
-
Make the Popup Move to the Current Customer On Open (6:01)
-
Use the TAG Property to Send the OrdCust Value Back from the Popup Form (5:41)
-
Add a Customer From Inside the Popup Form (3:10)
Section 12: A CLASSIC Double Loop Walk Thru
Section 13: Summary and Conclusion
