New Features in Total Visual CodeTools 2010

The VBA code parser that underlies the Code Cleanup, Code Delivery, and Unused Variable Analysis supports the new code and syntax in Office 2010/2013/2016 including the use of conditional compilers (e.g. #IF.. #ELSE.. #ENDIF) that is common for developers supporting both 32 and 64 bit environments.

For situations where the same variable is defined more than once based on the conditional compiler directives, the first definition is used (for Code Cleanup and Delivery).

After Total Visual CodeTools performs the analysis to cleanup or deliver your code, it prompts you to review the results before applying the changes. A new feature lets you bypass this step if no serious errors were encountered. This allows the entire process to complete without intervention. It is especially useful if you’ve successfully performed this task on your project before.

A new option for Code Delivery removes line continuation characters from your code so each line in on one line no matter how long it is.

You can now select multiple target controls and automatically generate the code you want to copy to all of them at one time.

Certain tools such as Clear Immediate Window and help are available when you are debugging your code. Previously, all the tools were disabled.

The forms for the builders and standards screen are now resizable to maximize their display on your screens.

The Recordset Builder has several enhancements:

• If opened from Access and referring to itself, when it's opened from another Access database, it’ll default to itself
• New field selection buttons: Select All and Clear All
• Adds brackets around field names with special characters in them
• For Access databases, it understands field data types, and assigns appropriate values for text, numeric and date fields.

By default, the Total Visual CodeTools menu appears on the main menu bar. Under Standards, you can change this so it resides under the Add-Ins or Tools menu instead.

The setting for the default Send To option is no longer under Standards. Total Visual CodeTools automatically uses the last option you chose the next time you open a builder.

The Message Box Builder has a new user interface that supports Windows 7.

The system modal option is removed because a message box is always modal, and options for right justification and right-to-left reading are added.

Total Visual CodeTools offers a feature to let you specify comment tags before and after each procedure’s error enabler and error handler so you can easily replace them if you decide to change your error management code.

Previously, the comment tags for these were hardcoded, for example:

  'TVCodeTools ErrorEnablerStart
  'TVCodeTools ErrorEnablerEnd

Now, you can specify these values under Standards, Error Handling.

Rather than a text file, the standards are now stored in a MS Access database. This eliminates some of the challenges supporting international languages and double byte characters.

If you install Total Visual CodeTools 2010 on a machine which had Total Visual CodeTools 2007, the previous settings are automatically imported. Otherwise, use the [Import Legacy CTS File] button from the Standards options under Manage Settings to retrieve the settings from an earlier version.