Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. exoscoriae

    Access VBA Nested For Loops

    Correect me if i am wrong, but what I believe Dauntless0522 is trying to do is the following: For every well with the same ID (as there will be many matches), compare the top and bottom rock perfs to the t=rock tops & bottoms. If the well name matches and the perfs meet the crieteria, then...
  2. exoscoriae

    Calculated Field

    Thank you for your time and bearing with my thread.
  3. exoscoriae

    Calculated Field

    I find that calling the calculation in the "On Current" portion of the form properties does calculate the field every single time the record is viewed.... unfortunately, even if the value i the same as it previously was - it flags the form as dirty and prompts for a save every single time. I...
  4. exoscoriae

    Calculated Field

    Update2 (no edit function?): I moved the sub call to right before it checks to see if the form is dirty, which makes the calculated value part of the me.dirty = true statement, rather then an after effect of it. This solves my problem! The only way this could be improved now is if those...
  5. exoscoriae

    Calculated Field

    Update: I found that if I specifically call the 'after update' sub function in Field1 from Field2 or Field3, then it will update. The problem I now have is that I have code for my form under 'Before Update' that checks to see if the form is 'dirty', and then prompts the user to save. This was...
  6. exoscoriae

    Calculated Field

    Hello all. I have several fields that are calculated from other fields. They are very simple calculations. My research has repeatedly shown that in an Access form, if I type in Me.Field1 = (Me.Field2 * Me.Field3) in the 'After Update" section, then anytime Field2 or Field3 is updated, this...

Part and Inventory Search

Back
Top