CAlling a module

[SVM]

I set up a module...now how do i use it?
How do i call it up in a form?

Thanks

 

[Dirk Goldgar]

I set up a module...now how do i use it?
How do i call it up in a form?

You don't call a *module* -- a module is just a container for code:
functions, subroutines, variables, property & type definitions, etc.
You can call a procedure in your module in a number of ways, depending
on whether it is a function or a subroutine and on what arguments (if
any) must be passed to it. What is the declaration of your procedure,
and what is it supposed to do?

 

[SVM]

Converting Currency to words using a module found at
http://support.microsoft.com/?kbid=210586
It is a function

 

[Phil Hunt]

Just do this:

CurrencyWord= myModule.ConvertFunction(..... whatever the function needs)

 

[Dirk Goldgar]

Converting Currency to words using a module found at
http://support.microsoft.com/?kbid=210586
It is a function

Did you read the complete KB article? At the bottom, it has a section
titled, "How to Use the ConvertCurrencyToEnglish() Function on a Form",
wherein it answers the exact question you are asking. Suppose you have
a control or field containing the number you want to display in words,
and the name of that control or field is "Amount" (for the sake of this
example). Then you would have a text box on your form with this as its
Control Source property:

=ConvertCurrencyToEnglish([Amount])

That should be all you need to do.