Total Visual CodeTools 2007: New Features

Supports Microsoft Access/Office 2007

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

Unused Variable Analysis

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.

Code Builder Enhancements

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.

Coding Tool Enhancements

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.

Code Cleanup and Delivery Enhancements

Total Visual CodeTools Code Cleanup and Delivery features are enhanced with the following new features:

• Support for the new Access/Office 2007 Syntax
• Improved viewing and searching of preview
• Messages, including alerts, are stored in an HTML report
• Option to permanently hide the initial warning screen (stored under Standards)
• Improved performance

Improved Standards Section

Total Visual CodeTools has a revised Standards section with:

• More control offered to individual builders
• New error handing templates for forms/reports
• Ability to add new data types for naming conventions
• Consolidated Recordset Builder variables under naming conventions

A New Microsoft Office Access 2007 User Interface

New User Manual

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

Pricing and Access Versions

Total Visual CodeTools Pricing for Visual Basic (VB6) and VBA such as Microsoft Office/Access/Excel/Word
Licenses		2007, 2003, 2002, 2000, VB6	97
	Single	$299	$299
	5 Seat	$899	$899
	Upgrade Single	$199	$199
	Upgrade 5 Seat	$599	$599
Premium Support Subscription
	Single License	$299	$299
	5 Seat License	$999	$999
	More Information
Also Available as part of:
	Total Access Ultimate Suite
	Total Visual Developer Suite
	Total VB Developer Suite
	Total Access Developer Suite
Runtime/Redistributable Version
Not Available
Licensing Information
Total Visual CodeTools is licensed on a per developer basis. Each developer who uses the program must have a license.

Back to Total Visual CodeTools Home