davetough
asked on
adding unbound and bound textboxes- cont from last question
Hello,
I have attached db- continuation on my last question.
when you open db- a form comes up.
There are two 'Parts Categories' boxes on form. 1 is unbound and 2 is bound.
Having both boxes perform same function to learn.
I want to add #-U [txtU] + #-V[txtV] + #-S[txtS]- and display results in Parts Categories boxes- but is not working.
The unbound textbox adds some of records correctly and other records not adding - (does not work when have NO value in one of records)-
and there will be times- where some levels are null.
The bound box- I have tried coding: me.txtPartsCategories= [me.txtU]+[me.txtV]+[me.tx
and not working at all.
thank you
base1.accdb
I have attached db- continuation on my last question.
when you open db- a form comes up.
There are two 'Parts Categories' boxes on form. 1 is unbound and 2 is bound.
Having both boxes perform same function to learn.
I want to add #-U [txtU] + #-V[txtV] + #-S[txtS]- and display results in Parts Categories boxes- but is not working.
The unbound textbox adds some of records correctly and other records not adding - (does not work when have NO value in one of records)-
and there will be times- where some levels are null.
The bound box- I have tried coding: me.txtPartsCategories= [me.txtU]+[me.txtV]+[me.tx
and not working at all.
thank you
base1.accdb
Sorry - Drop the brackets:
Me.txtPartsCategories = Nz(Me.txtU, 0) + Nz(Me.txtV, 0) + Nz(Me.txtS, 0)
You can also do this in the control source propery of txtPartsCategories like this:
= Nz(txtU, 0) + Nz(txtV, 0) + Nz(txtS, 0)
Me.txtPartsCategories = Nz(Me.txtU, 0) + Nz(Me.txtV, 0) + Nz(Me.txtS, 0)
You can also do this in the control source propery of txtPartsCategories like this:
= Nz(txtU, 0) + Nz(txtV, 0) + Nz(txtS, 0)
I have updated your database. The null values are causing problems.
With the bound value, often designers will use a query to do the calculation. That way, any field changes force an automatic recalculation and you don't need the VB code.
In 2010, the calculated field offers the same advantage. I added the Calculated Field in the table, but not the form.
I set the default value to 0 for the field with nulls and I changed the update code to use 0 when no range was selected. You can hide the 0 with a format mask which I place in the second field for you to review. base1.accdb
With the bound value, often designers will use a query to do the calculation. That way, any field changes force an automatic recalculation and you don't need the VB code.
In 2010, the calculated field offers the same advantage. I added the Calculated Field in the table, but not the form.
I set the default value to 0 for the field with nulls and I changed the update code to use 0 when no range was selected. You can hide the 0 with a format mask which I place in the second field for you to review. base1.accdb
ASKER
thank you-mbizup am i correct that
Me.txtPartsCategories = Nz(Me.txtU, 0) + Nz(Me.txtV, 0) + Nz(Me.txtS, 0)-should work in bound texbox-
am getting #name? error- maybe i am doing something wrong-
DoDah- am having hard time opening your db- is it 2010- i have 2007
thank you
am going to look this over tonight and understand it
i think i can see some code in 2010forms code
Me.txtPartsCategories = Nz(Me.txtU, 0) + Nz(Me.txtV, 0) + Nz(Me.txtS, 0)-should work in bound texbox-
am getting #name? error- maybe i am doing something wrong-
DoDah- am having hard time opening your db- is it 2010- i have 2007
thank you
am going to look this over tonight and understand it
i think i can see some code in 2010forms code
That code goes in the open event not the control source.
My second suggestion will work in the control source.
My second suggestion will work in the control source.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great Help- thanks again- my keyboard went dead -and was unable to write
yes i wonder if those special charachters
yes i wonder if those special charachters
me.txtPartsCategories= NZ([me.txtU],0) + NZ([me.txtV],0) + NZ([me.txtS],0)