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.

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 procedures.

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 snap.

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.

Bookmarker

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 database window.