PDA

View Full Version : Auto Calculating in remaining field.



aligahk06
05-15-2010, 09:21 AM
Dear All,

Attach file is for ur ref.
I,m having a form with following fields.
Amount,retention and total amount.
i.e the retention and total amount field is dependent on Amount field.
Suppose if i put 10000.00 in Amount field then retention field 10% of Amount automatically calculate and
in total amount field the 90 % of Amount field auto calculate.

Finally Amount Words field auto according to numeric value of total amount field.
Any Help?
e.g

Amount is 10000.00
Retention 1000.00
Total Amponut 9000.00
Text in Amount word fields.Nine thousand only.

Rgds,

Aligahk06

OBP
05-16-2010, 03:34 AM
The value calculation is straightforward, but the conversion to text is more complicated.
I have found this KB article which shows how to do it.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=285

I can't open your database as it is in Access 2007 format.