|
|
 |
| |
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. |
|
| |
|
|
|
|
|
|
 |
| |
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. |
|
| |
|
|
|
|
|
 |
| |
Default: 'Private'. Scope refers to the availability of a variable, constant, or
procedure for use by another procedure. |
|
| |
|
|
|
|
|
 |
| |
Default: 'Sub'. On choosing 'Function' or 'Property get', a returntype is required: the combo-box to select a returntype wil be enabled. |
|
| |
|
|
|
|
|
 |
| |
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. |
|
| |
|
|
|
|
|
 |
| |
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. |
|
| |
|
|
|
|
|
 |
| |
'Keywords': ByRef, ByVal or
ParamArray. See the help file for details.
Default is 'blank' (no keyword). |
|
| |
|
|
|
|
|
 |
| |
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). |
|
| |
|
|
|
|
|
 |
| |
Optional. To ensure that an argument gets a proper value, specify the type here. |
|
| |
|
|
|
|
|
 |
| |
If the argument is optional, this value will be used in case no argument value is passed. |
|
| |
|
|
|
|
|
 |
| |
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'. |
|
| |
|
|
|
|
|
 |
| |
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'. |
|
| |
|
|
|
|
|
 |
| |
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. |
|
| |
|
|
|
|
|
 |
| |
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. |
|
| |
|
|
|
|
|
 |
| |
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 ©'. |
|
| |
|
|
|
|
|
 |
| |
Closes '3J - The Procedure Creator
©' (saving your settings). |
|
| |
|
|
|
|