Your clients may speak a different language, here is a
database showing its possibility to spell numbers in English, French, or Italian.
Other languages can be added too.
Testing.
Open the demo database (Access 97). From the immediate window
(Debug Window), execute:
HowToUse
Using it as a developer.
Be sure to have an access to the tables
supplied in the demo, preferably just copy them (their French name will unlikely
collide with your existing tables name). Copy the class module
PolyglothSpellNumber. The other module, HowTo, is just use for the demo, here up,
while the two queries and the form are used to help adding a new language, here
down; they are not needed in a working environment..
Instantiate an object from the class
PolygothNumberSpeller for each language to be used, then, use the method
Initialise, with an s, not a z, to specify the language to be used by the object.
See the module HowTo for examples. The number to be used for a given language
can be read from the table Langues. NOTE: the demo, as supplied, doesn't know
how to spell in German, sorry. Use the method Spell to spell a plain number, use
SpellMoney to spell an amount of money (in this case, the secondary unit is
assumed to be in a "quantum" of 1/100). See those method in the class
PolyglothNumberSpeller.
Adding a new language.
Instructions are supplied in the form "adding a new language".
Having found no-one claiming to know how to
spell right numbers in German, Spanish, Portugeese, Russian, ... I haven't
included those languages in the demo and I ignore if the model I have built can
be use for those languages or not. If you have questions, you can contact me, in
French, or in English at
Vanderghast@msn.com.
|