Read the digit with Sound

[Guest]

I want to play the sound based on the field value.

Example : OnFocus Event of the field, it will read the total by sound. Like
if the total is

12,589.33. The it need to produce the sound : Twelve Thousand Five Hundred
Eighty Nine ANd Thirty

Three Fils.

I tried so many methods to do it. But failed.

Please advice me the VBA Code. Which can make me complete this facility in
the Form.

Regards.


Irshad

 

[Douglas J. Steele]

You can use the code in http://www.mvps.org/access/modules/mdl0001.htm at
"The Access Web" to translate from 12,589.33 to the text "Twelve Thousand
Five Hundred Eighty Nine And Thirty Three" (you'll have to make some minor
changes to the code, as you've already been told in response to other times
you asked about this).

Once you've got the text equivalent of the number, take a look at my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access" for one way to use SAPI to speak that text. You can download the
column (and sample database) for free from
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Guest]

Thankyou so much for your reply.

Regards.

You can use the code in http://www.mvps.org/access/modules/mdl0001.htm at
"The Access Web" to translate from 12,589.33 to the text "Twelve Thousand
Five Hundred Eighty Nine And Thirty Three" (you'll have to make some minor
changes to the code, as you've already been told in response to other times
you asked about this).

Once you've got the text equivalent of the number, take a look at my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access" for one way to use SAPI to speak that text. You can download the
column (and sample database) for free from
http://www.accessmvp.com/djsteele/SmartAccess.html