its funny but when i changed the folder names that my access file was in it and the form name it solved my problem.
my folder name contain - in it and i delete it . and my form name was in persian language i make it into english.
dblSumOfPoints = dblSumOfPoints + (Nz(![kpi1], 0) * Nz([Text44], 0)) + (Nz(![kpi2], 0) * Nz([Text47], 0)) + (Nz(![kpi3], 0) * Nz([Text48], 0))
'dblSumOfRewards
i mean in this code what is th meaning of dblSumOfRewards. i cant understand
hey what is going on with dblsumofRewards there? i think i can remove it from there and nothing change. am i true?
Private Sub Form_Current()
Dim dblSumOfPoints As Double
Dim dblSumOfRewards As Double
With Me.RecordsetClone
If Not (.BOF And .EOF) Then...
I didt add any code i just used the code u add and i have some problems:
hey thank u but some of points dont work corectly and show wrong numbers,
and the weird thing is when i click on each textboxs in form the form recalculate te numbers and show another number in all textboxs when i just...
hey thank u but some of points dont work corectly and show wrong numbers,
and the weird thing is when i click on each textboxs in form the form recalculate te numbers and show another number in all textboxs when i just change my focus on text boxes
How can i calculation out of form?. [text1] and [text2] and [text3] are numbers that people should type in form. they are not stored in tables. so i just can calculate in form.
Hi there
i have access 2016 and new to this forum. thank u for helping me.
i have some fields in this multiple records. and some textboxs. and i have field that Multiply these and show answer in every record of form. its like this =[field1]*[Text1]+[field2]*[Text2]+[field3]*[Text3]. and that...