By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

wana build bank statement in Acces

P: 2
hi friends
i am the new member of this forum. i need help in MS Access.
i want to prepare accounts of my company so i want to prepare the record of my bank statement but the problem is that i could not calculate the balance of my table. i have six columns

1 ID
2 Transaction Date
3 Particulars
4 Debit
5 Credit
6 Balance


i want this that when i entered the value in debit or credit then the value in balance will be automatically updated. And automatically add or subtract from the previous balance and show the current balance.

kindly helpme what formula should i use to calculate the balance kindly reply me soon

THANKS IN ADVANCE
Sep 5 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
In form design view go to the textbox control holding Debit Value. Open the properties and in the After Update event build the following code:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Debit_AfterUpdate()
  2. Me.Balance = Me.Credit - Me.Debit
  3. End Sub
  4.  
Do the same on the Credit textbox:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Credit_AfterUpdate()
  2. Me.Balance = Me.Credit - Me.Debit
  3. End Sub
  4.  
hi friends
i am the new member of this forum. i need help in MS Access.
i want to prepare accounts of my company so i want to prepare the record of my bank statement but the problem is that i could not calculate the balance of my table. i have six columns

1 ID
2 Transaction Date
3 Particulars
4 Debit
5 Credit
6 Balance

i want this that when i entered the value in debit or credit then the value in balance will be automatically updated. And automatically add or subtract from the previous balance and show the current balance.

kindly helpme what formula should i use to calculate the balance kindly reply me soon

THANKS IN ADVANCE
Sep 5 '06 #2

P: 2
well MR. mmccarthy i still have problem Please tell me in detail it shows me the error that the

"MS access cannot find the macro 'Private Sub Debit_AfterUpdate() Me.' "
this macro does not exist or the macro is new and has not been saved.


Plz help and if you can build the Ms Access file then plz attach a file which can calculate the bank statement . HELP

thanking you in advance
Sep 7 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Ali I just used this as an example. Go to the control (textbox) on the form that holds the debit value. Go to Properties, events and in the After_Update event put [Event Procedure]. Click on the button with dots to the right and the VBA editor will open. The private sub and End Sub lines will be there just put the code in the middle.



well MR. mmccarthy i still have problem Please tell me in detail it shows me the error that the

"MS access cannot find the macro 'Private Sub Debit_AfterUpdate() Me.' "
this macro does not exist or the macro is new and has not been saved.

Plz help and if you can build the Ms Access file then plz attach a file which can calculate the bank statement . HELP

thanking you in advance
Sep 7 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.