Class Modules Better Global Constants in VBA with Dot-Driven Development My global constant "C" class--with PredeclaredId = True--is a great alternative to traditionally-declared global Public Const's.
Class Modules Great Intro to Class Programming in VBA Former Access MVP Ben Clothier's primer on class programming in VBA should be required reading for all Access developers.
Class Modules Caching Object Instances in VBA Classes Simplify the object initialization code in your class modules without sacrificing performance using this easy technique.