473,324 Members | 2,370 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Credit & Debit

Hi All,

m Himanshu Saxena from new delhi

i want to overwrite the value in text box as:-

DATE PartyId Dr Cr
01/04/08 ABC 500.00 0.00
05/05/08 ABC 0.00 200.00
15/05/08 ABC 0.00 500.00


Total Amount 500.00 700.00

Now in that case m create a Text box with Name Of "CH"
After that m create one Value Box with Name of "Total"

Now m do a coman in Total box =[DRSUM]-[CRSUM]

In thtat case i hv recd a entry as -200.00 in Total Box

now m create Private Sub As

Private Sub Report_CH(Cancel As String)
If([Total>0]) Then StrCpy "Ch,Credit"
Else
StrCpy "CH,Debit"
End If
End Sub

But this is not working in my Report in "CH" Text Box

Can any one please Help me in this matter ..................
Oct 7 '08 #1
1 1585
debasisdas
8,127 Expert 4TB
Hi Himanshu

Welcome to Bytes.com (our new identity)

Feel free to post questions in the related forum only by choosing from under the blue bar on the top of your page.

Please follow the posting guidelines in every new post/reply.

Please specify your post/question clearly.

Regards
Debasis
Oct 7 '08 #2

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

Similar topics

3
by: Justin Koivisto | last post by:
OK, I know a few of you out there use OSC and many of you have also modified it a bit, so I am hoping someone has done something similar... I have the CC payment module installed, not a problem...
4
by: Raj | last post by:
Hi I am developing a POS system for a retail business and I need to support accepting the credit and the debit cards. This authorization interface need to be integrated to the my POS...
4
by: Michelle A. | last post by:
I have a form that takes in a credit card number, just a series of numbers 1234123412341234. When they get to the "Review" page and display all the information a user has entered, I would like the...
6
by: Chris Davoli | last post by:
We want to process credit cards/debit cards on our web site. We are using VB.net, so if we could get some vb.net components to validate and handle the transactions, or a web service that we could...
1
by: anna cypher | last post by:
I am considering taking on a project that requires the app to charge credit / debit cards. I have no idea how to do this... I'm sure buying the actual reader and getting it to work with an app...
1
by: Bill D'Innocenzo | last post by:
There are many functions available that implement credit card identification and number validation -- meaning you can decide, based on the number, if a card is a MasterCard or Visa and if the...
1
by: securedcardss | last post by:
http://card.2youtop.info secured credit card card credit instant secured card cash credit secured card
0
by: style_craze_cool | last post by:
Hi. I've just started a data processing firm here in Karachi, Pakistan; So we are looking for data processing campaigns we offer 99.5 accuracy & we can even work on credit if your company/firm is...
3
by: emannasser | last post by:
i need ho know how o calculate or how to get the blance debit credit = balnce 100 20 = ? it dosent show the balnce in the form .....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.