Word func in access

Question

I use rswords macro in excel to convert  no into word...like =rswords(40), gives a answer of Rupees forty only, now in My access query i want to convert some nos into words (indian rupee), is that possible in acess.

Answer 1

If you need a version that uses the Indian numbering system with lakh for 10000, crore for 10000000, etc., you can use the code from http://www.eileenslounge.com/viewtopic.php?f=27&t=22506&p=175082#p175082

The workbook attached to that post contains a module with the code you need. You can easily copy the code into a module in your database.

Answer 2

You'll easily find code for converting numbers to a text string by googling around a little, e.g  the module at:

https://support.microsoft.com/en-us/kb/213360

This is published for Excel, but will work in Access.  It would be an easy task to modify the code to output the values in rupees and paise with a few 'find and replace' operations (I've done it for pounds and pence) or to return a value in rupees only.  If you wish to add the word 'only' to the return value that again would be a simple modification.

Answer 3

Can you view the code in the add-in, or is it locked?

Answer 4

Actually it is a addins in excel, how can i add addins in access

Answer 5

Copy the code for the rswords function (plus supporting functions if necessary) into an ordinary module in your Access database. You can then use rswords in queries and in the control source of text boxes on forms and reports in your database.