FMS Home FMS Software Development Team Blog FMS Facebook Page FMS Twitter
Jump: Search:

Total Visual CodeTools

Total Visual CodeTools manual

Microsoft Office Access 2010 Version
is Shipping

New Verrsion

Supports Office/Access 2010, 2007, 2003, 2002, 2000, and Visual Basic 6.0!

Also available for
Access 97


View all FMS products for Microsoft AccessAll Our Microsoft Access Products

CodeTools Info:

Why CodeTools?

 

"Total Visual CodeTools is by far my favorite third-party product."

Alison Balter, Author, Conference Speaker, Instructor

More Reviews

Additional Info:

 

 

 
Create, Maintain, and Deliver better Microsoft Access, Office, VBA and VB6 code with Total Visual CodeToolsTotal Visual CodeTools for Microsoft Access, Office, VBA, and VB6Coding Tools for Microsoft Access, Office, VBA, and VB6 Download Trial of Total Visual CodeTools for VB6 and VBA/Office/Access

Microsoft Access 2010New Features in Total Visual CodeTools for Microsoft Access 2010

Total Visual CodeTools 2010 is the seventh major version of the product since its debut as Total Access CodeTools in 1996. The latest version introduces the following new features:

Supports Microsoft Office 2010, 32 bit Version

Total Visual CodeTools 2010 supports the 32 bit version of Microsoft Office 2010. It also supports Office 2000 through 2007, Visual Basic 6, and Windows 7 and earlier operating systems.

It does not support Office 2010, 64 bit version due to the complete change of the VBA IDE add-in integration.

VBA Code Parsing Supports Access/Office 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 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).

Code Cleanup and Code Delivery Faster with Apply Changes Option

New Code Cleanup and Delivery Option to Immediately Apply ChangesAfter 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.

Code Delivery Removes Line Continuation Characters

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.

Copy Control Builder Supports Multiple Target Controls

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

Long Text/SQL Builder Supports Query Retrieval and Converts Tabs and Spaces

The Long Text/SQL Builder now lets you retrieve the SQL string from the query of a database you specify. No need to open the SQL pane of query to copy and paste the text yourself.

There are also new options to simplify the conversion of SQL queries and text blocks to VB6/VBA code. Tabs can be automatically replaced by spaces, and extra spaces can be eliminated:

Select Case Builder Supports Text Blocks and Numeric Ranges

The Select Case Builder now makes it easy to specify multiple case and variable assignment values. Simply paste a block of text with the values you want and the code is generated. You can also generate a numerical range of case values by specifying the start, end, and step values:

Recordset Builder Defaults to Current Database and Simplifies Selections

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.

Message Box Builder Enhanced

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.

Standards let you specify where Total Visual CodeTools appears on your menusThree Locations for Total Visual CodeTools on Your Menus

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:

Tools Available During Debugging

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

Code Cleanup Error Enabler and Handler Tags are Customizable

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.

Default 'Send To' is Remembered

Default Send To is MaintainedThe 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.

Screens are Resizable

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

Redesigned Storage of Standards and Improved International Support

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.


Pricing and Access Versions

Total Visual CodeTools 2010 supports all 32-bit VBA hosts from Access/Office 2000 through 2010, plus Visual Basic 6. Total Visual CodeTools is also part of our suites.

Total Visual CodeTools Pricing
for Visual Basic (VB6) and VBA such as Microsoft Office/Access/Excel/Word

License Price 2010, 2007, 2003,
2002, 2000, VB6
97

Single $299 Buy Now Buy Now
5 Seat $899 Buy Now Buy Now

Upgrades

Single $199 Buy Now Buy Now
5 Seat $599 Buy Now Buy Now

Premium Support Subscription

Single $299 More Information
5 Seat $999

Also Available as part of:

Total Access Ultimate Suite
Total Access Developer Suite
Total Visual Developer Suite
Total VB Developer Suite

Runtime/Redistributable Version

Not Applicable

Licensing Information

Total Visual CodeTools is licensed on a per developer basis. Each developer who uses the program must have a license.

Press Release Announcing the New Version

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © FMS, Inc., Vienna, Virginia
Celebrating our 28th Year of Software Excellence