wana build bank statement in Acces

[ali ammad]

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

[MMcCarthy]

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:

Private Sub Debit_AfterUpdate()
Me.Balance = Me.Credit - Me.Debit
End Sub
 

Do the same on the Credit textbox:

Private Sub Credit_AfterUpdate()
Me.Balance = Me.Credit - Me.Debit
End Sub
 

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

[ali ammad]

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

[MMcCarthy]

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