I write the small foxpro prg the same thing iwant in access how should writ the code in click event below my foxpro prg
close all
clear
set stat off
set talk off
set safe off
set cent on
set date brit
sele a
use intcal
store 0 to mob,madd,mrec,mcb
store date() to mdop
@ 10,10 say [Enter Amount of Advance : ] get madd pict '9,99,999'
@ 12,10 say [Enter Date of Payment : ] get mdop
read
mdor=mdop
@ 14,10 say [Enter Date of Recovery : ] get mdor
@ 16,10 say [Enter Rate of Recovery : ] get mrec pict '9,99,999'
read

do while mrec>0
   appe blank
   repl ob with mcb
   repl add with madd
   if mdor<=mdop
      if mcb+madd>mrec
         repl recovery with mrec
      else
         repl recovery with mcb
         mrec=0
      endif
   endif
   repl cb with ob+add-recovery
   repl date with mdop
   mcb=mcb+add-recovery
   mdop=gomo(mdop,1)
   madd=0
enddo
close all
clear
set stat on
set talk on
set safe on
retu

__________________
Mohamed Mohiddin
Officer

Mohiddin,

There may be a foxpro dev about here that can help... but you may have a wait.

If you can break this code down into what it is you want to perform/achieve, we might be able to help come up with code for it, but at the moment, to be fair, I cant tell your variables from your keywords.

Thanks for your replay
My table name is IbbMstr there are Obal (Opening balance) ,Rdate (Recovery Date, Ramt (Recovery Amount), Cbal(Closing balance) fields for example below like
Obal Rdate Ramt Cbal
5000 01/01/2006 1000 0
Now My problems is in my form(frmIbb) when I go to click the button in IbbMstr table all field should automatically Update like below
Obal Rdate Ramt Cbal
5000 01/01/2006 1000 4000
4000 01/02/2006 1000 3000
3000 01/03/2006 1000 2000
2000 01/04/2006 1000 1000
1000 01/05/2006 1000 0
I don’t no how should the code please help me


Mohamed Mohiddin
Officer