Total Visual CodeTools

Total Visual CodeTools manual

Microsoft Office Access 2016, 2013, 2010 Version
is Shipping

New Verrsion

Supports Office/Access 2016, 2013, 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 Free trial of Total Visual CodeTools for Microsoft Access, Office, VB6 and VBA

Frequently Asked Questions for Total Visual CodeTools


What version of Total Visual CodeTools do I need and what versions of Microsoft Access/Office/VB6 does it support?

  • Total Visual CodeTools 2010 is the latest version and supports the latest VBA/Visual Basic 6.0 environments:
    • Office, Access, Excel 2016, 2013 and 2010 (32 bit), 2007, 2003, 2002 (XP), and 2000.
    • Other VBA environments
    • Visual Basic 6 (VB6)
  • For Access 97, Total Access CodeTools 97 is available.
  • Support is not available for the 64-bit version of Office 2010 and later
    • By default, Office 2010 and later install the 32-bit edition. Most users are running the 32-bit version Office even if the operating system is 64 bit.
    • Total Visual CodeTools 2010 support Office 2016, 2013 and 2010 32-bit on 64-bit versions of Windows

Check the Product Compatibility Chart for version information for all of our products.

For information on the history of Access versions, visit our Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History page.


Can I try Total Visual CodeTools before I buy it?

Yes. Download the free Trial Version to try Total Visual CodeTools before you buy it.

Also, remember that FMS products come with a 30-day money back guarantee, so you can buy with confidence!


Does Total Visual CodeTools Require Administrator Rights?

Total Visual CodeTools is in Visual Basic 6.0.

Visual Basic 6.0 products may not require admin rights if the user already has these components below installed (this should not be an issue for Windows NT 4 or later):

  • Microsoft OLE 2.40 for Windows NT and Windows 95
  • Microsoft Tabbed Dialog Control 6.0 (tabctl32.ocx)
  • Microsoft Visual Basic virtual machine (msvbvm60.dll)
  • Microsoft Windows Common Controls 6.0 (mscomctl.ocx)
  • Microsoft Windows Common Dialog Control 6.0 (comdlg32.ocx)

Total Visual CodeTools does not appear on my Access Add-ins menu

Total Visual CodeTools does not appear on the add-ins menu/ribbon in the main Access program.

Total Visual CodeTools is an add-in for your module editor. It appears in the VBA module editor. To use Total Visual CodeTools in Access, open any module (or press Alt-F11) to open the VBA editor.

If Total Visual CodeTools is properly installed, it appears on the menu as "Total Visual CodeTools".

Under the Total Visual CodeTools standards, you can modify the location where it appears so that it can also appear under the Add-ins or Tools menus.

If you still can't find the Total Visual CodeTools menu item, it may be temporarily disabled. Look under Add-ins, Add-in Manager to find "Total Visual CodeTools 2010" then change the Load Behavior to Startup/Loaded. If it's not on the list, it's not installed properly. You may need to uninstall and reinstall it.


Total Visual CodeTools is missing from the VBA or VB6 IDE Menu

When you install Total Visual CodeTools, the setup program creates registry entries so the Microsoft Visual Basic 6 and Office programs can integrate it into their add-ins menu.

Total Visual CodeTools installs as a “loaded” add-in. This means that whenever you start Visual Basic or the Office Visual Basic Editor, the Total Visual CodeTools menu item and toolbar are ready to go.

Because of Microsoft’s support for VBA/VB6 add-ins on a user rather than machine basis, if you installed Total Visual CodeTools under a different Windows login name, you’ll need to load it again.

For Visual Basic 6 (VB6)

For VB6, you can simply select it from the Add-ins Menu.

For VBA (Microsoft Office, Access, Excel, Word, etc.)

For VBA, you need to update the registry. Exit your VBA host program before doing this. For your convenience, a REG file is included in the installation directory of Total Visual CodeTools that you simply need to run. Locate the file named VBA-Addin.reg, and double click it. A warning may appear requesting administrator rights or other confirmation. Click [Yes] to confirm the registry change, and the registry is updated for the current user. The registry file contains the following information:

Total Visual CodeTools 2010

[HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins\TVCTLVBA.CAddInConnect]
"FriendlyName"="Total Visual CodeTools 2010"
"LoadBehavior"=dword:00000003
"Description"="Total Visual CodeTools 2010 from FMS, Inc. (www.fmsinc.com)"
"CommandLineSafe"=dword:00000000

Total Visual CodeTools 2007

[HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins\FMSVBEI.CAddInConnect]
@=""
"FriendlyName"="Total Visual CodeTools"
"LoadBehavior"=dword:00000003

The next time you run your VBA host, Total Visual CodeTools appears on the module editor menu.


Why do I have the error "Update Wizard not initialized properly" when trying to run the Update Wizard for Total Visual CodeTools?

This error occurs when you attempt to run the Update Wizard by double clicking the "Update.exe" directly instead of running it from the Windows Programs Menu shortcut.

This is because the update.exe file requires parameters to run and return the correct information. In order to determine if there is an update available for this product, please run the update wizard program from the Windows Programs menu or Windows Metro menu.


I receive an error when I run Total Visual CodeTools

  • Error 3021, "No current record"
  • Error 40179, "Requested type library or wizard is not a VBA project."

This issue can occur in an Access database that contains a corrupt object (e.g. a module or code behind form or report). In many cases, such corruption can be resolved by following the steps to decompile and recompile your database.

If you still encounter this error after following these steps, please contact us so that we can be of further assistance.


Total Visual CodeTools Error: The add-in could not be installed because it is missing a UsysRegInfo table.

This error occurs if you are attempting to install Total Visual CodeTools using the Microsoft Access Add-Ins menu. Please review the following information to setup and use Total Visual CodeTools on your system.

Running the Setup Program: To install Total Visual CodeTools on your computer, run the SETUP.EXE program located on the CD (or download). Once the Setup program starts, enter your information as prompted and complete the setup Installshield wizard.

Total Visual CodeTools is designed to be used via the Microsoft Office Visual Basic for Applications IDE (i.e., VBA Editor) or the Visual Basic 6.0 Program Editor if you have VB6 installed on your system. To launch the Total Visual CodeTools main menu, simply open the VBA IDE from your Office program (or VB6) and the Total Visual CodeTools top level menu is available at the top of editor toolbar. There is also a separate toolbar for this product that displays by default. Our latest version of the product supports Visual Basic 6.0 as well as the 32-bit editions of Microsoft Office 2000, 2002, 2003, 2007, 2010, 2013, and 2016.

If you still do not see the Total Visual CodeTools menu option within the Visual Basic for Applications (VBA) editor, please check to ensure that the Total Visual CodeTools add-in process is currently running by selecting Add-Ins > Add-in Manager. Then, check to ensure that the item entitled "Total Visual CodeTools" is currently loaded. In most cases, you may wish to ensure that the checkbox entitled "Load on Startup" is also selected.