Section 1: Introduction and Overview
Section 2: How to Create a Hack Proof Read-Only Database
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
Section 5: Database Design Scenario - Loan Company
Section 6: Conclusion
