Click in or hover over the fields for their functionality. Use the tab-pages for navigation.
     
 
Top
  Required. Just enter or paste a name without any tags. They can be added automatically, depending on your preferences (see page 3).
If you want to leave without creating a procedure, press 'Cancel'.

In the combo-box the number of procedures (as indicated on the 'preferences' page) you created before ('history') will be displayed, if selected. If so, the table will only store unique procedurenames.
A maximum number of 50 names can be saved and, consequently, displayed in the combobox: convenient if you need to create procedures that have slightly different names.
 
         
Top
  Name after processing if tags has been selected (on 'Preferences' page).
In the example above, a public function is created, hence 'pf', as a prefix, is added.
 
         
Top
  Default: 'Private'. Scope refers to the availability of a variable, constant, or procedure for use by another procedure.  
         
Top
  Default: 'Sub'. On choosing 'Function' or 'Property get', a returntype is required: the combo-box to select a returntype wil be enabled.  
         
Top
  The difference between a function and a sub is the fact that a function will give you a return value\result. Either that it was executed properly (or not; a boolean value) or an 'internal' result like the outcome of a calculation or a lookup.
The return value\result has to be of a certain type, which you have to select here.
 
         
Top
  Indicates that an argument is not required. If used, all subsequent arguments in arglist must also be optional and declared using the Optional keyword. Optional can't be used for any argument if ParamArray is used.  
         
Top
  'Keywords': ByRef, ByVal or ParamArray. See the help file for details. 
Default is 'blank' (no keyword).
 
         
Top
  An argument could be passed into a function or procedure, e.g.: Weekday(#12-31-2002#,1): 2 arguments are passed into this function: a date (between #) and the 'first' day of the week (Sunday = 1, Monday = 2 etc.; Weekday() is a VBA-function).  
         
Top
  Optional. To ensure that an argument gets a proper value, specify the type here.  
         
Top
  If the argument is optional, this value will be used in case no argument value is passed.  
         
Top
  Should the genereated code be copied to clipboard or into module you are working in within mdb? On tab\page 'Preferences' you can set the default behavior for this checkbox (on the main page) when opening '3J - The Procedure Creator ©'. However, by clicking on the 'OK' button, the option selected on the main page will prevail. Default is 'Yes'.  
         
Top
  Check this box if you create a completely new function or procedure. 
The first line will be (e.g. and depending on your selections): 'Private sub msCalcHours()'; the last line then will be: 'End sub'. 
If this box is unchecked, only the 'body' of the procedure will be copied to the clipboard, in case you want to add error handling to an existing procedure in your project: enter or paste the name and click 'OK'.
On tab\page 'Preferences' you can set the default behavior for this checkbox (on the main page) when opening '3J - The Procedure Creator ©'. However, by clicking on the 'OK' button, the option selected on the main page will prevail. Default is 'Yes'.
 
         
Top
  As selected on the 'Preferences' tab, indicates where a new procedure should be inserted in module.
If '3J - The Procedure Creator ©' is opened via the menubar, only the options
'Top of Module' and 'Bottom of Module' will be available, as no insertion point in the module is known.
'Top of Module' is default.
 
         
Top
  For faster access, without the need for an external file (although provided), the help file has been integrated. Just click the control you want more information about, then press this button. The cursor will move to the 'Help' tab, displaying the helptopic and it's related topics. Doubleclick on the related topic to have it displayed in top textbox. Click on 'Go To' button to go to selected control.  
         
Top
  Clicking on this button will copy the generated code to the clipboard. If you checked 'Paste into current module', it will be pasted into the module your working in from which you invoked '3J - The Procedure Creator ©'.  
         
Top
  Closes '3J - The Procedure Creator ©' (saving your settings).