Total Access CodeTools for Microsoft Access 97
Standardize New and Existing Module Code
"FMS is out front with Access add-ins. Total
Access CodeTools makes it a lot easier for developers to create and
maintain Access applications.
Tod Nielson, General Manager, Microsoft Access Business Unit
Best Access Add-in
Within one week of using Total Access CodeTools, you will recognize tangible benefits:
- It Takes Less Time To Write Code:
Because you can generate entire procedure blocks with the Procedure
Builder, coding time is reduced. Additionally, the SQL Builder, Long
Text Builder, Message Box Builder and Select Case Builder write 75% of
the code you need—automatically!
- Your Application Contains Fewer Errors: Generated
code is error-free, and the Code Cleanup tool can add valuable
error-checking elements such as error handlers and variable naming
- Your Applications Is More Maintainable: Because Code
Cleanup can standardize all your code to adhere to the standards you
define, your application is more maintainable. This is especially
important in development environment where multiple programmers are
working on the same project. Code Cleanup, and the use of the code
builders makes sure that everyone is on the same page.
- Your Code Is More Readable:
With the addition of standardized indentation, comments, variable naming
conventions, and standardized error handling, the code in your
application becomes much easier to read and understand.
Total Access CodeTools is the leading collection of tools for writing and
modifying Access module code. Simplify your job of developing Access
applications. If you write module code or inherit/maintain module code
written by others, Total Access CodeTools is the tool for you!
The Total Access CodeTools Toolbar
This powerful collection of tools and utilities makes it easier to:
Ship Robust Applications
- Add error handling to all procedures that lack it. If you are creating
databases for others, you know the importance of error handling in every
procedure. Manually doing so is extremely time consuming. Let Total
Access CodeTools apply the error handling you specify to every
procedure. You can even pass your error handler the procedure name!
- Add line numbers to every line of code.
This feature is worth the price of the product!
With line numbers and an error handler, you can pinpoint the exact line
where an error occurs. In most cases knowing the offending line lets you
immediately determine the problem ("Wow, how did it get there?").
Eliminate or greatly reduce the need to talk to users, reduce the time
you spend replicating crashes, and fix bugs faster than ever!
Quickly Write Solid Code with our Code Builders
- New Procedure Builder to create procedures with error
handling and comment structures you specify.
- New Property Builder to create class properties with
error handling, comments and variable settings.
- Message Box Builder
to visually create MsgBox commands.
- SQL Builder
to convert query SQL strings to word wrapped variable assignments.
- and more!
Standardize and Clean Up Code (especially inherited projects you otherwise can't read):
- Standardize indentations (indent IF statements, DO loops, etc.).
- Apply a variable naming convention you specify. For instance, all
integers start with "int", strings with "str", globals with "g", etc.
- Add module comment blocks including a list of all procedures in the
- Add comment blocks to each procedure.
- Sort procedures (move globals to the top, etc.).
- Split multi-line DIM statements and multi-line commands separated by
- Specify line spacing between procedures.
- Add "Option Explicit" to modules that lack it.
Total Access CodeTools provides the features you need to create robust
applications from beginning to end. After installing the program, you have a
floating toolbar available while you develop your Access applications.
- Code Cleanup
Code Cleanup takes existing code and standardizes it. It's great for
cleaning up your old code and especially useful for taking over someone
else's work. It applies your standards across all your modules by adding
error handling, standardizing indentation, applying variable naming
conventions, adding modules and procedure comments, and much more. Most
importantly, you can add line numbers to every line of code so your
error handler can pinpoint the exact line where a crash occurs. Use this
tool on prototype code or inherited projects to quickly apply consistent
standards. All parameters are fully user-configurable.
Click Here for more information.
- Code Builders
- New Procedure Builder
The Procedure Builder makes it easy to create new procedures that
automatically contains all the important elements: A comment block,
creation date information, error handling, and naming conventions. Just
type in your new procedure name and Total Access CodeTools generates all
the code for you. Then press a button and the new procedure is inserted
into your module.
- New Property Builder
The Property Procedure Builder does the same thing as the Procedure
Builder, but is specifically designed to build Property Let/Set/Get
- SQL Builder
The SQL Builder takes the SQL string out of any query in your database
and converts it to VBA code with line continuation characters and
word-wrapping on reserved SQL words such as SELECT, FROM, WHERE, etc.
- Message Box Builder
The Message Box Builder makes creating MsgBox statement easy. Visually
create your message box by selecting the icons, buttons, default button,
title, message, and other options. Preview and test it. Total Access
CodeTools takes care of the details including code to handle the
response from the user.
- Other Builders
The Select Case Builder and Long Text builder make inserting new code a
- Constants Generator
The Constants Generator generates the code to initialize constants
naming each object in your database. A real must if you want to avoid
hardcoding object names in your database code.
- Other Tools
BookMarker makes it easy to keep development notes and track tasks on
specific objects in your database.
- Access Information Tool
The Access Information Tool quickly displays all the settings and
environment options for the current installation of Access and your
database. Information on hardware and the operating system is also
included to help solve your toughest debugging problems.
- Database Tools
Database Tools give you a convenient launch pad for opening, designing,
and copying database objects without having to hunt for the Access
Includes our widely read "VBA Coding Techniques and Tips": 16 techniques
for writing better VBA code.
For more detailed information and screen shots of each feature,
see our Detailed Product Specifications Sheet.
Code Cleanup is one of the most powerful members of the Total Access
CodeTools feature set. It allows you to apply a number of operations on all
the code in your database, including:
- Adds Option Explicit to Modules
the Option Explicit setting are the leading cause of bugs in Basic code.
You can tell Code Cleanup to add Option Explicit to every module that
- Add Error Handling to Procedures
Robust error handling is a requirement for professional application
development. Unfortunately, it’s a tedious process: you have to write
the error enabler, the exit point, and the error handler into every
procedure in your database. Code Cleanup can do this for you
automatically by adding error handling to every procedure that lacks it.
You can use our default error handler, or customize your own.
- Standardize Code Indentation
Standardize code indentations including defining how many spaces each
indentation level takes. This option also takes care of splitting
multiple statements from one line into multiple lines.
- Sort Procedures
Define how you want procedures to be sorted within each module. For
example, you can have public procedures put first, then property
Let/Set/Get procedures, and then private procedures. Additionally, you
can specify the order for Let/Set/Get procedures within a single
property name. This is a must for large modules—it becomes much easier
to find the code you need in a sorted module.
- Add Module and Procedure Comments
Add a customizable comment header to the top of each module and
procedure. Use our default header, or customize it to fit your needs.
Module comments can also automatically include a list of all procedures
in a module, including their parameters—a great way to see what's in a
module at a glance. Comments can include the current date, and the name
of the user.
- Apply Variable Naming Conventions
Rename your variables to conform to naming conventions you specify. For
instance, if you dim a variable named "Name" as a String, it becomes "strName".
The tags are completely customizable and you can use prefixes or
suffixes. Use Code Cleanup so all your code is consistent.
Set the Number of Lines between Procedures
With the new VBA Editor's "Full Module View", procedures quickly become
non-standard in terms of the number of blanks lines between them. Use
this feature to specify exactly how many lines should be between
- Add Line Numbers for Error Detection
Add line numbers to every line of code so your error handler can
pinpoint the exact line if your application crashes. Great for debugging
and knowing exactly where your program needs to be fixed!
For more detailed information and screen shots,
see our Detailed Product Specifications Sheet.
Pricing and Availability
Total Access CodeTools is available for Access 97. Total
Visual CodeTools is available for Access 2000 through 2010. This product is available as a single product or as a part of
a multi-product suite.