Setup Tasks | A2P School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Microsoft Access VBA for Non Programmers - YOU Can Do This!

Section 1: Introduction

Course Overview (3:08)
Setup Tasks (2:59)

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

On Open Event, Me Keyword and Orderby (5:54)
Subroutines for Form Controls, VBA Editing Shortcuts (5:25)
Modify Subroutines to Sort DESC, More Error Handling (10:24)
Section 3 Conclusion and Review (1:30)

Section 4: Use Instant Search to Learn More About the Keyboard, Recordsets and Variables

Expanding the Keydown Subroutines (6:35)
Using Public Variables (6:13)
Building the Search Criteria (6:36)
Field Names and Reserved Words (8:40)
Using a Recordset and Bookmarks (5:37)
Enhancing Our Instant Search (11:06)
Section 4 Conclusion and Review (3:12)

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

A CLASSIC Situation that MUST be Handled Correctly (1:18)
Database Overview and Why you Want One Table (4:03)
The Code Behind the Recalc Button (6:31)
Doing Total Queries and Making the Subroutine a Function (5:56)

Section 13: Summary and Conclusion

Congratulations and Next Steps (5:38)

Teach online with

Setup Tasks

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock