Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
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 February 19th, 2007, 09:24 AM
Registered User
 
Join Date: Jan 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default append record whith do while function

Hi
I have create two table one tblIBB with fields name, ob(loan),
lsdt(loan sanction date),lrdt(loan recovery date),aoi(amount of installment),
cb(closing balance) another table IbbMst with above same fields
Now my problems is in my form one append button is there when I click
the append button I want append the record in table tblIBB in to IBBMst
with do while tblIBB.aoi>0
I want replace ob with cb
and if lrdt<lsdt
replace cb with ob-aoi
replace date with lsdt
for eg.
tblIBB
  ob lsdt lrdt aoi cb
 1000 01/01/07 01/02/07 100 0
Now I want append the records in table in IBBMst like below
 Ob date(lrsdt) aoi cb
1000 01/02/07 100 900
900 01/03/07 100 800
800 01/04/07 100 700
700 01/05/07 100 600
600 01/06/07 100 500
500 01/07/07 100 400
400 01/08/07 100 300
300 01/09/07 100 200
200 01/10/07 100 100
100 01/11/07 100 0
In above meathead how should the code in click event







Similar Threads
Thread Thread Starter Forum Replies Last Post
new record function getting locked in place jeremy1048 Access 1 April 7th, 2008 08:44 AM
Import Access data whith varying columns dbellavi SQL Server DTS 15 January 30th, 2008 06:23 AM
last or curremt record append queries mohiddin52 Access VBA 7 January 19th, 2007 08:28 AM
How do I append a single record ??? prashanthmcr SQL Language 3 December 14th, 2005 05:40 PM
Function to Find a Record me2357 Access VBA 5 March 10th, 2005 03:22 PM





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