If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
user defined functions
where are saved these functions ? o how do i save one ?
and how can i run it with a command button ? |
#2
|
|||
|
|||
user defined functions
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. |
Thread Tools | |
Display Modes | |
|
|