Recent content by masons

  1. M

    Microsoft Access failed to create the Visual Basic Module

    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.
  2. M

    Sum Multiple records and display in text box #ERROR

    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
  3. M

    Sum Multiple records and display in text box #ERROR

    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...
  4. M

    Sum Multiple records and display in text box #ERROR

    thank u, what did u do?
  5. M

    Sum Multiple records and display in text box #ERROR

    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...
  6. M

    Sum Multiple records and display in text box #ERROR

    Download the db u sent here before
  7. M

    Sum Multiple records and display in text box #ERROR

    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
  8. M

    Sum Multiple records and display in text box #ERROR

    you are amazing
  9. M

    Sum Multiple records and display in text box #ERROR

    i get error again can u check my db? i shared it
  10. M

    Sum Multiple records and display in text box #ERROR

    can tell me more about this? and it get syntax error and its about this line: If Not (.BOF And .EOF)
  11. M

    Sum Multiple records and display in text box #ERROR

    sure. thank u for helping
  12. M

    Sum Multiple records and display in text box #ERROR

    they Are unbound textboxs and in footer
  13. M

    Sum Multiple records and display in text box #ERROR

    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.
  14. M

    Sum Multiple records and display in text box #ERROR

    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...
Top Bottom