• Usage
  You can invoke '3J - The Procedure Creator ©' in two ways:

For an existing procedure -

A. As a builder

  1. Right-click and click on 'Build...' in the Popup menu
  2. The list with installed builders is displayed, select one of the three options and
    double click on the selected option or click 'OK':
    a: '3J - The Procedure Creator ©' to open the main screen
    b: '3J - TPC - Xpress' to insert error handling without any screen opening
    c: '3J - TPC - Xpress - Add New' to open a light form to add a new procedure
  3. '3J - The Procedure Creator ©' opens (2a only), and the procedure name from which the add-in is invoked, is placed in the procedure name combobox
  4. If required, you may alter the default settings to customise
  5. Click 'OK'
  6. The errorhandling code is inserted into procedure.

                

'3J - TPC - Xpress - Add New' will display this form, which is a stripped version of the original add-in, to achieve faster loading. The settings are taken from the main form, but quickly changed here. 'Open 3J' will open the add-in itself.

 

B. From the Add-Ins Submenu - English MS Access version only

  1. In a module, on the menubar select: 
    Tools > Add-ins > '3J - The Procedure Creator'
  2. '3J - The Procedure Creator ©' is opened
  3. Type the procedure name in the procedure name combobox, select an existing procedure from the dropdown list or paste it
  4. If required, you may alter the default settings to customise
  5. Click 'OK'
  6. The error-handling code is inserted into the procedure.

 

 
For a new procedure - both methods will open '3J - The Procedure Creator ©', but you have to enter the procedure name manually. If the procedure name can not be found in the module, the first and last line are included automatically.