Search results

  1. VasiuF

    Calculate the sum of a field in a while loop but after an iteration the variables sum is reset

    Hello everyone I need some advice I have to calculate the sum of a field in a while loop but after an iteration the variables credit1,credit2,sum1 and sum2 are reset (take the value 0). I don't know where I'm wrong. Can you help me ? ok, leave it at that, it was a simple question ...
  2. VasiuF

    Solved run-time error '6' Overflow

    excellent! :D(y) the solution you gave me arnelgp , works perfectly Thank you all for the promptness and advice given that really helped me
  3. VasiuF

    Solved run-time error '6' Overflow

    You are right, 0 by 0 can be any variable in the sum_1 ... 4
  4. VasiuF

    Solved run-time error '6' Overflow

    I just try with nz function bat initially was not
  5. VasiuF

    Solved run-time error '6' Overflow

    next m_mediaan in which I have to do another calculation with all 4: m_medias1 .... m_medias4 and m_nr1 ... m_nr4 next line of code
  6. VasiuF

    Solved run-time error '6' Overflow

    of course I marked the error, but I stopped running for the print screen
  7. VasiuF

    Solved run-time error '6' Overflow

    It's about m_suma4, you can see in watch window
  8. VasiuF

    Solved run-time error '6' Overflow

    Howdy, I have a problem with a calculation in which I have a value of zero can you help me with some advice to solve the situation? I also attached a print screen dim m_suma1..m_suma4, m_nr1 ... m_nr4 as long thanks
  9. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    thanks for all your help and especially strive4peace for promptness and useful advice you've given me good things to think about I plan to restructure my database a bit and will ask another question when I need more help
  10. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    https://www.photofunny.net/cat-image-processing/convert-picture-drawing-a-pencil :)
  11. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    at the moment you will see that after entering the study year ( at lost_fosus event) I will filter "subjects" and go through them in a while but this does not help me, because I have to take each recording separately and edit it then save it with the "OK Save" button
  12. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    strive4peace did you have time to take a look at the attachment?
  13. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    in detail you can click on the codm or name to edit
  14. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    the picture is made by a small application :) after the real picture
  15. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    Hi all I would need the following sequence to write it in vba access: I have 2 tables: table1 (field1, field1, field1) and table2 (field1, field1, field1) where table1.field1 = table2.field1 LEAVING A FIELD FORM select table1 filter by field1 and field2 go to the first recording after the...
  16. VasiuF

    Solved calling the value of a field from a main form -> subform into a query

    Hello strive4peace thank you very much for all your advice these are also good solutions in the meantime I had done something like that SELECT codm, Mid ([codm], 1,2) as SPEC, Mid ([codm], 3,1) AS ANSTD, Mid ([materials.code], 4.2) AS NRORD, Right ([codm], 4) AS PROMO FROM matters WHERE Mid...
Top Bottom