| |
|
|
| |
| |
|
Click in or hover over the fields for their functionality. Use the tab-pages for navigation. |
|
|
|
|
| |
|
|
| |
|
|
 |
| |
The header in a procedure consists of the command on what to do in case an error happens: 'On error goto Err_', where 'Err_' should be extended to a full label (usually the procedure name is added).
If you leave this command line out, it will be added automatically.
In an header also comment-lines can be put: explaining what the procedure does (documenting your labor!), when it was created, by whom etc.
By default the following will be visible:
On Error GoTo Err_@3JProc
'*******************************************************
'*** Created with '3J - The Procedure Creator ©'
'*** Date: #D
'*** By: $U
'*** Purpose:
'*******************************************************
You may however put 'On Error GoTo Err_@3JProc' underneath the header:
'*******************************************************
'*** Created with '3J - The Procedure Creator ©'
'*** Date: #D
'*** By: $U
'*** Purpose:
'*******************************************************
On Error GoTo Err_@3JProc
'3J - The Procedure Creator ©' will add the procedurename (as entered
or pasted into procedure combo box on main page) by replacing the placeholder ('@3JProc').
You can personalise the other lines. For standard insertion codes, click
here: Insertion Codes |
|
| |
|
|
|
|
|
|
| |
For your convenience,'3J - The Procedure Creator ©' can contain up to 3 custom headers. Just clear out the header text box, enter your header text and assign it to one of the customheader options on the right by giving it a name (just click in the textbox and enter a name), so that you can select it later. Erasing the text of an header and wiping out its name, will free it up. The 'Default' option can not be erased. The option you selected on closing, will be used next time you open '3J - The Procedure Creator ©'. It might look like this:
 |
|
| |
|
|
|
|
|
|
| |
Exit clause; not much to edit in this part, unless you got a perfect exiting-function of course. |
|
| |
|
|
|
|
|
|
| |
What this add-in is all about: once an error get trapped, it will be handled by the code that you put here. Default it will display the error number and message, which is rather poor, as you would like to know when and where exactly an error occurred.
So, instead of adding a fairly basic error handler that only displays the number and description of the
error, it would be useful to get more data, like the form or even control or function that the
error occurred in. And, in an environment where users have to report the error to their administrator(s), it would be
advisable to have the error logged, so that it can be retrieved, without guessing what went
wrong, as users usually don't pay attention to details that are relevant for debugging or might not even aware of (like
procedures\functions that were invoked in the background...).
The registered version of '3J - The Procedure Creator ©' offers this all! You will be able to add global error handling to
your procedures: a general error handling function will provide the user and you as a
developer with vital information. Beside that, the errors will be logged in a separate textfile, so that even in case
your mdb gets corrupted, you will be able to have a look where things went wrong.
Selecting the 'Global' option will display this confirmation screen:
The custom errorhandler code will be replaced by the global
errorhandling-sub:
In your current project (that is the mdb from which you invoked '3J - The Procedure Creator ©'), a module,
'3J_modGlobalErrorHandling', will be added after switching to global errorhandling:
|
|
| |
|
|
|
|
|
|
| |
By using these placeholders, the following data will be added when creating the procedure:
- #D: date & time in general date-format (Windows Control Panel).
- $U: username.
Note: Before any login procedure for the database is established, this will be 'Admin' (via the function: CurrentUser()).
- Click 'Proc. name' to insert the procedure name at any location ('@3JProc' is displayed in textbox, as placeholder)
- Click 'Object name' to insert the object name of the module
'3J - The Procedure Creator ©' is invoked from, at any location ('@3JObject' is displayed in textbox, as placeholder)
(Don't forget the single quote when adding a comment-line).
|
|
| |
|
|
|
|
|
|
| |
All the non-labels lines of a procedure can be indented ('tabbed') to the right. Enter the number of spaces you want the lines to be indented. Default is 4 spaces. |
|
| |
|
|
|
|
|
|
| |
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. |
|
| |
|
|
|
|
|
|
| |
|
| |
|
| |
|
|
|
