CAlling a module

  • Thread starter Thread starter SVM
  • Start date Start date
SVM said:
I set up a module...now how do i use it?
How do i call it up in a form?
Click to expand...

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?
 
Just do this:

CurrencyWord= myModule.ConvertFunction(..... whatever the function needs)
 
SVM said:
Converting Currency to words using a module found at
http://support.microsoft.com/?kbid=210586
It is a function
Click to expand...

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.
 
Back
Top