G.1. Why Implement Naming Conventions?
No one has to use naming conventions. Developers can and do write applications without applying (or enforcing) naming conventions. However, they can save a lot of time, money, and prevent needless frustrations by making it easier and faster to read and interpret code, whether it is something you wrote last week or last year, or code from another developer.
Naming conventions convey many benefits. As mentioned earlier, they are like sharing a common language. Typically, that is important if the application will be shared, but it may also be applied to the individual developer who has to work with a program that was shelved for a couple of years. Some of the obvious benefits of using a naming convention include the following.
They make object names more informative so developers can quickly understand an application's structure and code
They provide a standardized vocabulary for team efforts.
They minimize conflicts when adding third-party products.
They allow code, tools, and code libraries to be shared across various VBA platforms.
They group objects and facilitate various sort options.
They can provide self-documenting program code.
They enhance search and replace capabilities.
They allow us to learn, modify, and incorporate code from others, including from magazines, reference books, the Internet, and our peers.
The naming conventions need to be an integral part of the basic design and be fully adopted before one stroke is committed to the database. ...
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
