Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old December 6th, 2006, 07:52 AM
Authorized User
 
Join Date: Dec 2003
Location: Vashi, Navi Mumbai, Maharashtra, India.
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
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
Reply With Quote
  #2 (permalink)  
Old December 6th, 2006, 07:56 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

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.
Reply With Quote
  #3 (permalink)  
Old December 16th, 2006, 04:54 AM
Authorized User
 
Join Date: Dec 2003
Location: Vashi, Navi Mumbai, Maharashtra, India.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Default


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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 11: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 03:58 AM



All times are GMT -4. The time now is 05:09 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.