Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Adding text boxes

Discussion in 'Information Technology' started by thusnani@gmail.com, Jul 28, 2006.

Tags:
  1. thusnani@gmail.com

    thusnani@gmail.com
    Expand Collapse
    Guest

    Im trying to add
    txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
    txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
    Now im to write some code so everytime i enter a number into a text box

    it will give me a running total in txtBoxTotal. What i'm having
    problems with is when the rest are null i get errors and the total
    doesnt come up in the bottom.
    Please let me know if anyone can help.
    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    Malaysia Hindus, Sikhs In Malaysia Appalled With University Textbook Ridiculing Their Faiths Breaking News Jun 14, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016
    India Protests in India Over the Desecration of a Holy Text Leave Two Dead Breaking News Oct 16, 2015
    Learn Punjabi Convert Punjabi text Language, Arts & Culture Oct 11, 2013
    Sikh Coalition Harmeet Kaur Took the Lead ! First to Respond to Textbook Challenge ! Sikh Organisations May 25, 2013

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    =Nz([txtBox1],0) +Nz([ txtBox2],0) + Nz([txtBox3],0) + Nz([txtBox4],0)
    +Nz([ txtBox5],0) + Nz([txtBox6],0) + Nz([txtBox7],0) + Nz([ txtBox8],0) +
    Nz([txtBox9],0) + Nz([txtBox10],0)


    --
    Rick B



    <thusnani@gmail.com> wrote in message
    news:1147979151.928644.35050@j55g2000cwa.googlegroups.com...
    > Im trying to add
    > txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
    > txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
    > Now im to write some code so everytime i enter a number into a text box
    >
    > it will give me a running total in txtBoxTotal. What i'm having
    > problems with is when the rest are null i get errors and the total
    > doesnt come up in the bottom.
    > Please let me know if anyone can help.
    > Thanks
    >
     
  4. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Check the help area on the Nz function

    txtboxtotal = nz(txtbox1,0) + nz(txtbox2,0) + etc
     
  5. SSG QuarterMaster

    SSG QuarterMaster
    Expand Collapse
    Guest

    If I understand this correctly your running total comes up null when you
    enter a value say into text box1 and the rest are null. If these entries are
    new entries into a table try setting the default value setting to a zero.

    "thusnani@gmail.com" wrote:

    > Im trying to add
    > txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
    > txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
    > Now im to write some code so everytime i enter a number into a text box
    >
    > it will give me a running total in txtBoxTotal. What i'm having
    > problems with is when the rest are null i get errors and the total
    > doesnt come up in the bottom.
    > Please let me know if anyone can help.
    > Thanks
    >
    >
     

Share This Page