Quick Find: Search for:

Technical Support

 

  Options

  Updates

  FAQs

  Newsgroups

  Register

 

 

 More Resources

  Free Tips

  Free Utilities

  Technical Papers

  Book Recommendations

View all FMS products for Microsoft AccessMicrosoft Access Resource Center

 

"I want to praise your support staff for being very helpful and friendly. Technical support was extremely helpful and gave me much more information than your average support person ever does. Thank you. " 
- Nora L.
 
  

 

Total Visual CodeTools Frequently Asked Questions


What version of CodeTools do I need?
What versions of Access/Office/VB does CodeTools support?

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


Can I try Total Visual CodeTools before I buy it?

Download the 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!


Total Visual CodeTools Does Not Appear on My Access Add-ins Menu

Total Visual CodeTools is an add-in for your module editor. Unlike other Access Add-ins, Total Visual CodeTools does not appear on the Access Add-ins menu. Instead, it appears in the VBA module editor (IDE). To use Total Visual CodeTools in Access, open any module (or select Tools | Macro | Visual Basic Editor) to open the VBA IDE.

If Total Visual CodeTools is properly installed, it is on the menu as "Total Visual CodeTools". Its toolbar may also appear if you chose to display it.


Total Visual CodeTools is Missing from the VB or VBA IDE Menu

When you install Total Visual CodeTools, the setup program creates registry entries so the Microsoft Visual Basic 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 VB/VBA 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 2007 that you simply need to run. Locate the file named VBA-Addin.reg, and double click it. This warning is displayed:

Click [Yes] to confirm the registry change, and the registry is updated for the current user. The registry file contains the following information:

[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 will appear on the code editor 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.

Back to Technical Support FAQ Page

Questions  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 21 Years of Software Excellence