This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA, Design and Advanced Methods Workshop 6
Section 1: Introduction
Introduction (4:41)
Section 2: How to Create Custom Shortcut Menus for Individual Form Controls
Overview of Shortcut Menus - A Demo of the Finished Form (3:42)
Create the Shortcut Menu Program (5:23)
Start Building Shortcut Menu Subroutine (6:39)
Finish the Shortcut Menu Subroutine (9:44)
Add Menu Groups and More Commands (10:25)
Modify Menus and Add a Call to a VBA Subroutine (12:37)
Section 3: Using the Triple State Property with Check Boxes
How to Use Triple State with Check Boxes (11:40)
Section 4: Build a Searchable List Box
Overview of Finished Form (9:20)
Start Modifying the Customer Form (11:47)
Start Customizing the Listbox (7:21)
Expand the Listbox Keydown Routine (11:04)
Continue Building the ListFind Function (9:15)
Add Backspace Functionality (8:18)
Add the Location of Customer Records Functionality (11:50)
Section 5: Quick Tips
How to Use Snapshots to Protect Data and Improve Performance (5:09)
How to Hide Objects in the Navigation Pane (4:48)
How to Create and Modify Custom Groups in the Navigation Pane (5:40)
Section 6: Design Challenge - Create Running Balances in a Subform & Update Main Form
Overview and First Steps (9:21)
Create the Running Balance in the Subform (10:33)
Finish by Updating the Main Form (5:28)
Section 7: Conclusion
Conclusion and Review (2:43)
Overview of Finished Form
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock