Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA, Design and Advanced Methods Workshop 8
Section 1: Introduction
Introduction (8:58)
WS8PROMO (3:04)
Section 2: Create an ADD or GO Combo Box
Create the Add or Go Box (10:35)
Create the ADD Part with VBA (7:29)
Create the GO Part by Adding to the VBA Subroutine (5:18)
Section 3: Creating and Using Cascading Combo Boxes
Get the Combo Boxes Working (9:14)
Make the Combos Filter the Data (10:58)
Section 4: Using Excel Date Functions Inside Access
Layout of the Form and Using the Excel NetworkDays Function (12:23)
Use the Rest of the Functions and Create a Module (7:40)
Section 5: Quick Tips
How to Create Custom Buttons for Your Forms (7:51)
Use Lightweight Forms for Fast Opening Menus (5:59)
Fix Tabbing Problems When Using Tab Control in your Forms (13:47)
Section 6: Design Challenge - Add the Capability to Offer Quantity Discounts
Demonstration of the Finished Database (8:33)
Review Qty Afterupdate and Build a New Subtable and Form (13:28)
Build a Query to Emulate Excel's VLookup Function (4:49)
Update the Qty Afterupdate Subroutine (9:22)
Make the Delete and Exit Buttons Work (5:45)
Section 7: Conclusion
Conclusion and Review (2:19)
Teach online with
Use Lightweight Forms for Fast Opening Menus
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock