Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Modules: Spelling number, in many languages (PolyGlot Number Speller)

Author(s)
Michel Walsh

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.

Download PolyGlot.zip
Polygloth Portuguese. zip (From Pedro Gil)
  See Screenshot

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.


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer