user defined functions

where are saved these functions ? o how do i save one ?
and how can i run it with a command button ?

On Fri, 4 Jun 2004 10:36:03 -0700, victor wrote:

where are saved these functions ? o how do i save one ?
and how can i run it with a command button ?

User Defined functions are functions you design yourself to return a
value.
They are stored in a Module.
On the main database folder, click on Modules
Write your function in the code window that opens:

Function DoSomething(FieldIn)
'Function code goes here
DoSomething = some value
End Function

Exit the module and save it under a name other than "DoSomething".

You can run it from a query, Control Source, or code event.

As a control source:
=DoSomething([FieldName])

From a command button event:
strResult = DoSomething ([FieldName])

From a query:
ExpoSomething([FieldName])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.