Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA, Design and Advanced Methods Workshop 1
Section 1: Introduction and Overview
Introduction (3:37)
Section 2: How to Create a Hack Proof Read-Only Database
Demonstration of the Finished Database (3:14)
Download the Work Database and Create a New Database (6:02)
Create the Open Subroutine (6:22)
Add Security to Prevent Changes (5:10)
Section 3: Create a Search Combo Box and Add Records to the Source Table on the Fly
Open and Examine the AddToList Database (4:04)
Before We Start, Let's Fix a Data Problem (6:07)
Create the Quick Search Combo Box (9:47)
Add VBA Code to Fix the Problems with Our New Combo Box (8:11)
Fix the Combo to Work with the Filters (6:50)
Using a Query to Solve the Problem (8:09)
Now Make it Do Something with the Selection (11:54)
Build the Not In List Subroutine (6:47)
Start Fixing the NotInList Routine (10:12)
Popup the Customer Form (8:57)
Don't Allow Adding Customers if Filters are Active (6:16)
Section 4: Controlling Record Location in Subforms
Overview of What We Want to Accomplish (3:24)
Start Building the Main Form To Order Button (7:19)
Finish the Code for Our To Order Button (5:55)
Test for Clicking the TO ORDER Button from the Main Form (5:31)
Create Code to Go to the Subform (5:34)
Create the Subform Subroutine then Call It (7:33)
Section 5: Database Design Scenario - Loan Company
Inspect Tables and Modify Structure (5:52)
Create the Assign Processor Form (8:55)
Create a Query to Get the Next Processor ID (6:40)
Add an Assign Button and VBA Code to the Form (10:27)
A Couple Last Things to Fix (7:41)
Section 6: Conclusion
Review and Conclusion (3:07)
Teach online with
Create the Quick Search Combo Box
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock