Total Visual CodeTools provides a robust set of tools to help you in the day-to-day development of Visual Basic (VB) and Visual Basic for Applications (VBA) code. The main features of Total Visual CodeTools are:

• Code Cleanup: Modifies existing code to standardize visual style, indenting, error handling, commenting, naming conventions and more. Works according to the styles and conventions you define
• Code Builders: A set of code builders that create new code using simple point and click forms. All generated code adheres to the standards you define
• Code Delivery: Prepares your code base for distribution in non-compiled environments. For example, applications distributed with Microsoft Office applications are not compiled to EXE files, making it easy to break into source code. Code Delivery obfuscates and compacts code to make it run faster and more secure
• Coding Tools: A variety of tools to make writing code in the Visual Basic/Office 2000 IDE easier
• Enterprise Standards Management: Your organization's standards for error handling, commenting, variable naming conventions, and visual style can be centrally managed and enforced across your entire development group
• Code Cleanup is one of the most powerful features of Total Visual CodeTools. Code Cleanup standardizes the code in your project to your specifications. Add error handling to procedures that lack it, standardize code indentations, apply your variable naming convention, insert comment structures, sort procedures, and many other powerful features and more. The result is code that is more readable, robust, and maintainable
• Visual Style

Standardizing the visual appearance of the code is probably the single most important factor for code maintainability. Choosing this option tells Code Cleanup to do the following:

• Standardize Code Indentation to a specified width with automatic indentation for programming constructs such as IF..ELSE..ENDIF, DO..LOOP, WITH..END WITH, etc
• Split multiple lines on one line separated by colons into separate lines
• Split single line If statements into separate lines with a closing End If
• Split Dim statements for multiple variables on one line into separate lines
• Standardize number of blank lines between procedures
• Standardize maximum consecutive blank lines

Procedure Sorting
Procedures can be inserted in any order in VB/VBA. This may be good, but it can also create a mess. Code Cleanup makes it easy to sort the procedures in your modules including property statements in class modules.

Module Comments
Add a standard module header to the top of each module such as a project name, creation dates, copyright notices, and ownership rights. A complete list of all procedure names and procedure definitions can also be added.

Procedure Comments
Add comment headers to each procedure. Although the program cannot determine what the code is actually doing and write the comments for you, it can take much of the drudgery out of the process of creating consistent comment headers for each procedure.

Property Comments
Inserts the specified property comment template into all the property procedures.

Error Handling
Error handling is one of the key attributes of robust applications. This feature inserts error handling code into your procedures that lack error handling, and allows you to specify separate error handling routines for regular modules vs. class modules. Error handling can also be added in a way to be automatically updated in the future.

Variable Naming Conventions
Rename your existing variables to conform to naming conventions based on the variable type (Integer, String, etc.). Every variable is given a prefix or suffix identifying its type with additional options for global and module level variables.

Option Explicit
Insert "Option Explicit" into the declarations section of every module that lacks it. One of the cardinal rules of writing reliable and maintainable code is to explicitly declare all of your variables. By adding "Option Explicit" to your module, you are telling Access to require variable declaration.

Remove Line Numbers
Removes the line numbers in your code. This is useful if line numbers were added to your code (say with the Code Delivery feature), and you now want to remove it.

Total Visual CodeTools provides several useful builders for your day-to-day development efforts. These builders allow you to automate and simplify the following processes:

Procedure Builder
This builder allows you to quickly create new procedures that adhere to a set of standards that you define. It allows you to specify comment headers, error handling, indentation, naming conventions, and global procedure identifiers.

Property Builder
You can write property procedures in VBA that allow you to define properties of the objects you define in class modules. The process of creating such procedures can be difficult. You can use the Total Visual CodeTools Property builder to quickly build the property procedures necessary to implement a property in a class module.

Long Text/SQL Builder
Adding long SQL strings into a module and easily viewing it usually requires breaking it into a multi-line statement. The SQL Builder automates this by automatically converting a SQL string to a series of VBA lines that assign the string to a variable. Like SQL text, you may need to assign a long text string to a variable in your code. The Long Text Builder takes a string and automatically generates the multi-line code necessary to assign the text to a variable.

Message Box Builder
Message boxes are a common feature in VBA driven applications. Unfortunately, VBA does not provide tools for visually creating message boxes. Even experienced developers need to refer to the manual or help system to determine the values of icons and button options. The Message Box builder lets you visually create a message box statement or function.

Recordset Builder
Creating recordsets against a table or stored procedure is another of those routine tasks, which could be error prone. The SQL Builder generates code for you depending upon your chosen table object or stored procedure object.

Select Case Builder
Typing Select...Case statements can be a tedious process, especially when there are many conditions. The Select Case Builder allows you to quickly create such statements.

Code Delivery provides the tools for the final preparation of your code before distribution. Easily add line numbers to all of your code so you can take advantage of VB/VBA's ability to pinpoint the exact line where an error occurs. You can also obfuscate your code for situations where you need to distribute your source code, but are concerned about its misuse. Code Delivery provides the following code operations:

• Line Numbering adds line numbers to every line of code. With this, if your error handler uses the ERL function, it can detect the exact line where a crash occurs
• Variable Scrambling lets you rename all your variables, constants, user defined types, and enum to nonsense names that another user would have great difficulty deciphering. An option is available to not modify public variables
• Remove Comments removes all your comments. There is a way to not delete certain comments if they are tagged
• Remove Blank Lines removes all blank lines
• Remove Indentations makes your code flush left
• Remove Debug Statements removes this debugging code
• Remove Stop statements removes stop commands
• In addition to Builders, Cleanup and Deliver, Total Visual CodeTools 2000 offers additional tools to help your coding work
• Close Code Windows: This tool makes it easy clean your development environment of code windows
• Clear Immediate Window: This tool makes it simple to clear the content of the Immediate window
• Block Commenter: This utility provides a better option to comment your code
• VBE Color Schemes: A tool which helps to visually organize the appearance of your Visual Basic Editor