Introduction and Overview
  • Introduction
  • Important NOTE on DOWNLOADABLE RESOURCES
How to Create a Hack Proof Read-Only Database
  • Demonstration of the Finished Database
  • Download the Work Database and Create a New Database
  • Create the Open Subroutine
  • Add Security to Prevent Changes
  • Print or Download a PDF with the Read Only Database Steps
Create a Search Combo Box and Add Records to the Source Table On the Fly
  • Open and Examine the AddToList Database
  • Before We Start, Let's Fix a Data Problem
  • Create the Quick Search Combo Box
  • Add VBA Code to Fix the Problems with our New Combo Box
  • Fix the Combo to Work with the Filters
  • Using a Query to Solve the Problem
  • Now Make it Do Something With the Selection
  • Build the Not In List Subroutine
  • Start Fixing the NotInList Routine
  • Popup the Customer Form
  • Don't Allow Adding Customers if Filters are Active
Controlling Record Location in Subforms
  • Overview of What We Want to Accomplish
  • Start Building the Main Form To Order Button
  • Finish the Code for Our To Order Button
  • Test for Clicking the TO ORDER Button from the Main Form
  • Create Code to Go To the Subform
  • Create the Subform Subroutine then Call It
Database Design Scenario - Loan Company
  • Inspect Tables and Modify Structure
  • Create the Assign Processor Form
  • Create a Query to Get the Next Processor ID
  • Add an Assign Button and VBA Code to the Form
  • A Couple Last Things to Fix
Conclusion
  • Review and Conclusion
  • BONUS Lecture! Learn Even More!