Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 6th, 2006, 07:52 AM
Authorized User
Join Date: Dec 2003
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Default want sample code

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
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
@ 14,10 say [Enter Date of Recovery : ] get mdor
@ 16,10 say [Enter Rate of Recovery : ] get mrec pict '9,99,999'

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
         repl recovery with mcb
   repl cb with ob+add-recovery
   repl date with mdop
close all
set stat on
set talk on
set safe on
Mohamed Mohiddin
Old December 6th, 2006, 07:56 AM
Friend of Wrox
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly


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.
Old December 16th, 2006, 04:54 AM
Authorized User
Join Date: Dec 2003
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is the code of sample application? rogerthis BOOK: Professional Java Development with the Spring Framework 1 November 27th, 2006 01:26 AM
I want to download sample code! caolei Pro JSP 6 May 26th, 2006 10:36 AM
Need Sample code okshilato SQL Server 2005 0 March 28th, 2006 10:41 AM
Sample Code mirouvor Java Databases 1 January 2nd, 2006 02:28 PM
Where the sample code? rbtcx BOOK: Professional C#, 2nd and 3rd Editions 5 August 21st, 2003 02:58 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.