Introduction
  • Course Overview
  • Setup Tasks
  • Important NOTE on DOWNLOADABLE RESOURCES
Start Learning VBA and Handling Errors
  • View Database Table and Forms - Review the Goal
  • Create Your First VBA Subroutine!
  • Fix a Syntax Error and Take Over the Keyboard
  • Use an IF Statement and DoCmd
  • Use ElseIf and a Select Statement
  • Runtime Errors, Error Traps and Program Stops
  • Break Into Programs and Infinite Loops
  • What Have You Learned in Section 2?
  • Section 2 Conclusion and Review
  • Section 2 Notes
Create Record Sorting Subroutines
  • On Open Event, Me Keyword and Orderby
  • NOTE on Label Events Not Appearing
  • Subroutines for Form Controls, VBA Editing Shortcuts
  • Modify Subroutines to Sort DESC, More Error Handling
  • What Have You Learned in Section 3?
  • Section 3 Conclusion and Review
  • Section 3 Notes
Use Instant Search to Learn More About the Keyboard, Recordsets and Variables
  • Expanding the Keydown Subroutine
  • Using Public Variables
  • Building the Search Criteria
  • Field Names and Reserved Words
  • Using a Recordset and Bookmarks
  • Enhancing Our Instant Search
  • What Have You Learned In Section 4?
  • Section 4 Conclusion and Review
  • Section 4 Notes
Interact With Other Forms and Pass Information
  • Open Another Form with a Button Click
  • Send Data to the Other Form
  • Modify a Form to Utilize Data Sent to it.
  • Intro to SQL and Using SQL in the Recordsource
  • Locate Same Record When Returning from the Form
  • Modify the Form to Remember the Sort
  • Create a Prompt to Save Changes
  • Activate the Add Customer Button
  • Testing for a Blank Record
  • Activate the Delete Button
  • What Have You Learned in Section 5?
  • Section 5 Conclusion and Review
  • Section 5 Notes
Add Multiple Interactive Pulldown Filters
  • Setup Rowsource for Dropdown Filters
  • Enable Editing In the Dropdown Filters
  • Set Dropdown Rowsources on the Fly
  • Create a Subroutine to Build All the Filters
  • Use the AfterUpdate Event to Rebuild the Filter
  • Setup the Clear Filter Buttons
  • Save the Filters when Closing the Form
  • What Have You Learned in Section 6?
  • Section 6 Conclusion and Review
  • Section 6 Notes
Build a Report Containing Complex Calculations
  • Inspect the Tables and Review the Goal
  • Creating a Summary Table with a Query
  • Building Our First Function and Saving Queries to VBA
  • Add a Delete Query and Create a Test Macro
  • Restructure Tables and Add a Second Query to our VBA Function
  • Figure Out How to Get the Days Between Orders
  • Doing the Steps With A Recordset
  • Calculate the Average Days Between Orders
  • Plug the Average Days into the Report Table
  • What Have You Learned In Section 7?
  • Section 7 Conclusion and Review
  • Section 7 Notes
Turn Off The Menu, Ribbon and Navigation Pane
  • View the Example of Removing the Nav Pane and Ribbon
  • Create the HideMenu subroutine
  • Call the HideMenu Subroutine from our Form
  • Make the Subroutine Toggle the Menus
  • Create a Startup Subroutine and an Autoexec Macro
  • Prevent Closing the Form and Activate the Exit Button
  • What Have You Learned in Section 8?
  • Section 8 Conclusion and Review
  • Section 8 Notes
How to Create and Modify Table Structures In VBA
  • Overview and Goal
  • Create Delete Subroutine and Make First Changes to SummRpt Function
  • Backup the SummRpt Function and Make the First Changes
  • Pull a Query from VBA Back to Design, Change It and Update VBA
  • Use TableDefs to Add a Field to a Table
  • Use TableDefs to Create a Table and Add FIelds to it.
  • Make Final Changes and Test the Modified Function
Section 11: USING VBA with SUBFORMS
  • Overview of the Tables in the Subforms Database
  • Overview of the Forms in the Subforms Database
  • Add OrderList as a Subform to the Customer Form.
  • Using an On Exit Subroutine to Capture the Order Number You Were On
  • Pass the Order Number to the Go To Order Button
  • Open the Orders Form and Move to the Specified Order
  • Create Code to Return to the Customer Form
  • Setup the OrdProdList Subform
  • Create a Total in the Subform
  • Update the Subtotal and Order Total