Take advantage of default collections and drop the extra name

Most DAO objects have several collections (e.g. Database has Querdefs, Tabledefs, and Recordsets). One of these collections is the default collection for that object and allows an abbreviated syntax. For example:


    dbEngine.Workspaces(0).Databases(0)

can be shortened to


    dbEngine(0)(0)

This shorter syntax is also slightly faster. Before rushing in and changing all your code, however, you might want to consider whether the loss in readability is worth the marginal increase in speed. This may be something to consider only when trying to squeeze the last drop out of some inner loop. Even then, tip #14 suggests a potentially far more effective way of doing this.