Only Total Visual CodeTools gives you the coding tools you need for Visual Basic and Office VBA development. As a developer, you have enough problems already--worrying about standards, commenting, error handling etc. should be automatic. And with Total Visual CodeTools, these issues are automatically handled.
Whenever I create a new procedure I manually have to type or paste in my comment header and error handling code which includes the procedure name.
The New Procedure Builder of Total Visual CodeTools automatically adds the comment and error handling blocks for you. Simply specify the procedure name and it builds the rest for you. You can use tokens to insert things like the current date, developer initials, procedure name, procedure type (function, sub, property), scope (private or public), etc. You can even specify Body Only if you want to insert the code in an existing procedure like an event procedure. Overall, it makes it easy for everyone on your team to create consistent procedures with the structure you've defined.
I have an error handler defined, but my application (or an inherited application) does not have error handling in all its procedures to call it. Manually adding the error handling, passing the procedure name, specifying whether it's Exit Sub or Exit Function is a real pain.
One of the most powerful features of Total Visual CodeTool's Code Cleanup feature is the ability to apply your error handling definition to every procedure that lacks an On Error command. This can be the same error handling structure you define for creating new procedures.
Code Cleanup automatically goes through your code and adds the error enabler at the top of the procedure and the error handler code at the bottom. You can specify where to use the name of the module, procedure name, procedure type (function, sub, property), and other tokens. You can choose whether you want Code Cleanup applied to one procedure, one module, modules you select, or all your code.
The application I'm supporting was written by someone who used a completely different style from me (or maybe it was me a few years ago). The code isn't indented properly, there are no comments, and no variable naming convention was used. What a mess. I can't even begin to fix things because it's so hard to read. What can be done?
Total Visual CodeTools cleans up existing code with ease (example). In addition to adding your custom error handling to procedures that lack it, Total Visual CodeTool's Code Cleanup feature lets you simply select a procedure, module, specific modules, or you entire project to apply your standards. You have complete control over all visual style settings, error handling, naming conventions, and commenting to clean up an entire application in minutes.
Choose among these options:
Total Visual CodeTools understands your code and can also apply Variable Naming Conventions. If all your Integer variables should start with "int" it can apply it. If you want global/public variables to be prefixed with a "g" and module level variables with an "m", it can apply that too. You can customize the naming convention you'd like and Total Visual CodeTools applies it.
Total Visual CodeTools can also insert comment structures you define at the top of each module and procedure. At the module general declarations level, it can even insert a list of all the procedures in the module and their parameters. For procedures, it can list each parameter of the procedure. It can't add comments defining the objects but does take the grunt work out of inserting the structures.
The Code Cleanup can be applied to one procedure, one module, selected modules or all the code in your application. Once you can read the code, you'll be much more productive.
Taking SQL from a query and converting it to code is a real pain. The text needs to be assigned to a variable, it's long and needs to be word-wrapped, and if there are quotes, I have to manually replace each quote with two quotes or single quotes.
The Long Text/SQL Builder lets you easily convert an existing SQL string into code that you can insert into your procedure. It automatically word-wraps and understands the need to word-wrap on reserved words (e.g. FROM, WHERE, ORDER BY, etc.) to make it readable. It also converts quotes so that they work. This hassle is now gone in the blink of an eye.
Writing code in ADO or DAO is not easy when you have to open a database, worry about connection strings, create a recordset to a table or query/view with its options, specify the fields to retrieve, and update those fields.
The Recordset Builder lets you quickly create a recordset against an Access database or DSN source like SQL Server. Open the data source and browse, add or edit records. Easily switch between ADO or DAO syntax. You'll never want to manually write code to open a recordset again!
I write lots of code. I need tools that add new procedures in a quick, easy, and standardized way.
Total Visual CodeTools includes many tools to write new code with just a few mouse clicks. Need to create a new procedure? Simply open the New Procedure Builder, type in a variable name and press Enter. Total Visual CodeTools automatically builds the procedure with naming conventions, error handling, and commenting, and inserts it directly into your project!
Total Visual CodeTools also has builders for property procedures, long text strings, recordset code (ADO and DAO are supported), select case statements, message boxes, and more. With the Copy Control Code Builder, you can even copy all the event procedures associated with one control to another control.
Visit the Builders Tour to see each builder and its screen details.
I want to be sure that my delivered applications are as robust as possible. I use Office applications like Access or Excel and know that my source code is included with my applications. I also use Visual Basic, and want real error handling.
The Code Delivery feature of Total Visual CodeTools helps you deliver robust applications or deliver your source code more safely (example):
If your error handler uses the ERL function, you can pinpoint exactly which line of code causes your application to fail. With this information, you can often identify the problem without a repro case or the need to talk to the end user. To have this feature, each line of your code needs to have a line number assigned. It's no fun writing code with line numbers in them, so the Code Delivery feature applies this once you are ready to ship.
For applications that must ship source code, like Excel, or if in VB or Access, you need to provide source code rather than an EXE/MDE, you may want to make it difficult for the recipient to use, understand or modify your code. The Code Delivery feature lets you:
The result is a smaller application that is harder to decipher.
The Code Delivery features can be applied to one procedure, one module, selected modules or all the code in your application.
I don't have time to switch between third-party tools and my programming environment. I want tools that are directly accessible from my IDE.
Total Visual CodeTools runs as an add-in in Visual Basic 6 and all Office VBA programming environments. Total Visual CodeTools is integrated directly in your IDE and available as a toolbar or menu. Simply select the tool you need, and its available. The code you generate from the builders can be inserted directly into your project (where your cursor is), copied to the clipboard, or sent to a file.
Ok, this all sounds fine. But I am part of a team. We have defined standards, and all my team members need to access coding tools in a standardized environment.
Total Visual CodeTools is fully Enterprise-Ready. All standards can be shared and managed at the team level. The standards you define as saved in a file that can be shared by all your users across the network. It is simple as that--all team members using Total Visual CodeTools will use the exact same standards. Need to update standards? No problem, Total Visual CodeTools supports full updating of existing standards.
I can't spend thousands of dollars per developer. I need a cost-effective coding solution.
At $299 per copy and only $899 for five, Total Visual CodeTools pays for itself very quickly. The savings in development time, improvements in quality, consistent coding styles, and a more robust and supportable application are why thousands of developers rely on Total Visual CodeTools to create better applications.
Supports Office/Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and Visual Basic 6.0!
Also available for
"Total Visual CodeTools is by far my favorite third-party product."
Alison Balter, Author, Conference Speaker, Instructor
Best Visual Basic Add-In