Recent content by aandress

  1. A

    After Update Event

    I have this code (as a sub) posted as an Event Procedure on the After Update of a field called ManagedAssetValue: Select Case ManagedAssetValue Case 10000 To 250000 Fee1 = ManagedAssetValue * 0.02 Case 250001 To 500000 Fee1 = ((250000 * 0.02) + ((ManagedAssetValue - 250000) * 0.015)) Case Is...
  2. A

    Function

    I have created the following function in VBA to run as an Event Procedure for the Fee1 field in a form... however... noting is showing up in the field... what am I doing wrong??? Here's the code I wrote: Private Function Fee1_BeforeUpdate(Cancel As Currency) If ManagedAssetValue >= 10000 <=...
  3. A

    SumIf Function

    Thank you SO much. Worked perfectly!
  4. A

    SumIf Function

    Is it possible to use a SumIf Function in a controlsource in a form? If so... what is wrong with this code: =SUMIF("AccumulatedValue","'Managed' = Yes") I want to add the values in the accumulated value field if the Yes/No box is clicked yes. Or... any other way to get the value of just the...
  5. A

    Calculated Control Code

    Can anyone tell by looking at this code what might be wrong with it? =DSum("[AccumulatedValue]", "Client Account Summary", "[Managed] = 'Yes'") I am trying to add the values in the accumulated value field in the Client Account Summary Form if the Managed field is clicked to yes. I have it in...
See more
Back
Top Bottom