New Features in Total Visual CodeTools 2007

Total Visual CodeTools is fully supported under Access/Office 2007, and supports the new VBA syntax.

The new Unused Variable Analysis feature helps you detect and eliminate unnecessary code from your project. Not only does it make your code more compact, the analysis may highlight problems where you thought the code should be doing or tracking something that it is not.

Easily find unused variables, constants, procedure parameters, classes, and user defined types and type elements.

Total Visual CodeTools 2007 includes various improvements that make the Code Builders more effective and easier to use, including:

• The New Procedure Builder has direct control of including comments and error handling, adds an error handler specific to forms/reports, creates the return value assignment for functions, and can automatically use the current procedure name.
• The Recordset Builder is completely redesigned to support Access 2007 ACCDBs, Access database and project objects, and selecting the current and shared databases. Easily create ADO or DAO code to browse, add or edit records in your selected data source (table or query) and fields.
• The New Property Builder offers options to include or exclude comments and error handling.
• The Long Text/SQL Builder includes options for word wrapping SQL text on AND/OR and JOIN syntax to make it easier to read your SQL strings.
• The Message Box Builder has an easier selection of icons, and a reorganized set of options for the return variable.
• The Select Case Builder lets you assign a variable for each case value, and automatically assign it a value with automatic incremental assignment for numbers.
• The Copy Control Code Builder includes a Generated Text section so you can preview the new code before adding it.
• The Format Builder is organized into tabs and allows you to add and save your own formats.
• Builders automatically generate new code as you change options.

Total Visual CodeTools' Coding Tools have been improved with the following enhancements:

• The Macro Recorder captures control key combinations, including clipboard operations. You can also record keystrokes in one module and play them in another.
• Close Code Windows includes an option to close only code or object windows in Visual Basic.
• The Block Commenter includes options to put the block of code in IF FALSE blocks, and allows you to add your comment text and remove indentations.

Total Visual CodeTools 2007 has a more modern user interface including support for Windows XP Themes, Windows Vista, and manifest files in VB 6.0.

A new professionally printed 166 page user manual and online context sensitive help.