Search results

  1. A

    Solved How to Create a Calculated Field for Fund Year based on 2 date fields?

    Thank you so much! It worked!!!!
  2. A

    Solved How to Create a Calculated Field for Fund Year based on 2 date fields?

    Good Morning, I need to create a calculated field called 'Fund Year' that will be based on 2 existing fields, 'Date of Service From' and 'Data of Service To' values. So I am thinking something like this, "if D.O.S from Year < Current Year and D.O.S to Year < Current Year then Fund Year = Current...
  3. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    You are a lifesaver. I am still learning Access as you can tell! :)
  4. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    Hi Pat - I tried your method using a calculated field in the query that is the record source of my form. I actually created 2 calc fields one for the AttestedAmount and another for the AttestedRecs and it worked! So no VBA required. I can't thank you enough for your help and suggestion. You...
  5. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    I made adjustments to my code so now I am getting this error
  6. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    I tried this VBA code but it's going down on the For Each line Private Sub AttestationCheck_AfterUpdate() Dim MyAttestedGrandTotal As Currency Dim MyRunningTotal As Currency Dim MyAttestedRecsTotal As Integer Dim ctrl As Control Dim ctrlType As String 'What control...
  7. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    Hi Pat - Thank you for your feedback. The Attested Amount is not an actual field I am storing on my table. It's an unbound control on the form that just shows the user the running total of the AttestedAmount when they check the Attest checkbox. So if the user checks Attest, it will add the...
  8. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    I am not sure I understand your method. All I am looking to do is verify if the checkbox control on my form is marked and if it is add the Amount Billed from control value to the Attested Amount Billed form control. If the user unchecks the control is should subtract the Amount Billed from the...
  9. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    I put together this VBA module that I am attaching to the AfterUpdate event property of the Attest checkbox control. Obviously, it's not going to work bc I am not good with VBA but it at least has the pseudo code that I am looking to program! Private Sub AttestationCheck_AfterUpdate() Dim...
  10. A

    Solved Controlling total amount billed and total record count based on checkbox selection

    Hi, I have a form with a Check box control called Attest. When the user marks the checkbox I would like the Attested Amount Billed to increment based on the Amount Billed value for the record/row. In addition, I would like the Attested Recs to count the number of marked checkboxes. How can this...
  11. A

    Controlling total amount billed and total record count based on checkbox selection

    Hi, I have a form with a Check box control called Attest. When the user marks the checkbox I would like the Attested Amount Billed to increment based on the Amount Billed value for the record/row. In addition, I would like the Attested Recs to count the number of marked checkboxes. How can this...
  12. A

    Help with VBA code to validate form controls

    Hi theDBguy - I sent you a copy of a modified version of my database yesterday. Please let me know if you received it. Thank you for your help with this endeavor. I really appreciate it! Again...I am not a VBA person so this is all new to me!
  13. A

    Help with VBA code to validate form controls

    Here you go. I had to clean up the data and sql links so all the tables are local.
  14. A

    Help with VBA code to validate form controls

    I am getting this error Is there a Set command for the Table object?
  15. A

    Help with VBA code to validate form controls

    Good morning, I am at it again with this code - would you please tell me what I am doing wrong with this? If Me.MemberID > 0 And Me.AuthNumber > "" Then If Me.MemberID = Table.dbo_tdAuthorization.[MemberID] And Me.AuthNumber = Table.dbo_tdAuthorization.[AuthNum] Then '...
  16. A

    Help with VBA code to validate form controls

    DBGuy would you help me with the validation code needed for the next steps?
  17. A

    Help with VBA code to validate form controls

    Hi - there's just too many records for a drop down. We are talking about almost 500,000! The SQL tables are populated from a portal application.
  18. A

    Help with VBA code to validate form controls

    I am SO sorry - yes, a member ID may have several AuthNum's (when looking at the dbo_tdAuthorization table) but the authorizations can have different start and end dates. So when I look at the Authorization's table I see multiple recs with different auths but the same Member ID.
  19. A

    Help with VBA code to validate form controls

    Yes, I will probably move validation but I am lost with how to continue the validation of the Auth number as I mentioned in my original post. Right now my code validates to see if the Member ID and the Auth Number exist on their respective tables. How to I validate the Member ID entered and the...
  20. A

    Help with VBA code to validate form controls

    I am wondering if this validation should be attached to the Save Button? When you attach to the individual controls, it looks like the order of the controls will impact how things are being validated.
Back
Top Bottom