Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from a less-experienced developer.
1. The video begins by walking the viewer through the process of creating a class module.
2. We then add properties and methods to the custom class that we create.
3. Finally we write code to instatiate the class, set the values of the custom properties, and execute a method of the class.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…