I have created a function and  saved it as a module of my database.
I am only able to execute the module by opening the design view of the
module, ensuring that the cursor is positioned in the text of the
function and pressing 'run'. When i use the runcode command in a macro i

am told that Access can't find the module specified.
    Is there any way that i can run the function either through a macro
or from a command button on a form.

Hi Paul,

Try prefixing Public to the function declaration.

Public Function HelloWorld()

end Function

Also, try to Compile and Save All MOdules before using RunCode.

HTH
--
Dev Ashish    (Just my $.001)
The Access Web ( http://home.att.net/~dashish )
----

:    I have created a function and  saved it as a module of my database.
:I am only able to execute the module by opening the design view of the
:module, ensuring that the cursor is positioned in the text of the
:function and pressing 'run'. When i use the runcode command in a macro i
:
:am told that Access can't find the module specified.
:    Is there any way that i can run the function either through a macro
:or from a command button on a form.
: