| | |
|
|
|
user defined functions |
|---|
| message from =?Utf-8?B?dmljdG9y?= on 4 Jun 2004 |
where are saved these functions ? o how do i save one ?
and how can i run it with a command button ?
|
| fredg replied to =?Utf-8?B?dmljdG9y?= on 04 Jun 2004 |
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:
Exp:DoSomething([FieldName])
|
|
Archived message: user defined functions (MS Access Database)
