Code Writer

Code Writer

One of the more repetitive tasks in Access is writing procedures in VBA code, when you need to put comments in, an exit point and an error handler. To make life easier (mainly for myself!!), I created a small Access Add-In that creates a procedure with a standard format so that I can paste it from the clipboard. The basic layout of the code produced looks like:

Public Function fFoo(strOne As String, strTwo As String) As Boolean
'   Created on 30 August 2002 by ???
'   Accepts:
'       strOne -
'       strTwo -
'   Returns:
'       A Boolean
    On Error GoTo E_Handle

fExit:
    On Error Resume Next

    Exit Function
E_Handle:
    MsgBox Err.Description & vbCrLf & "fFoo", vbOKOnly + vbCritical, "Error: " & Err.Number
    Resume fExit
End Function

I have left this as an open add-in, so that you can modify the text and format of the code as you required.

You can download an Access 97 version.

Top

Last modified at 06/06/2006 14:54:06