Search results

  1. EM2021

    Updating Report that uses a query with changing fields

    That did the trick! I appreciate you.
  2. EM2021

    Updating Report that uses a query with changing fields

    Here's my union query: (SELECT [Campaign Summary].Gf_CnBio_ID AS ConstitID, [Campaign Summary].Gf_Fnds_1_01_Amount AS SplitAmount, [Campaign Summary].Gf_Cmps_1_01_Campaign_ID AS CampaignID, [Campaign Summary].Gf_Cmps_1_01_Description AS CampaignDescription, [Campaign...
  3. EM2021

    Updating Report that uses a query with changing fields

    I've built a report based on queried data that has conditions 1,2,3,4,5,6,7,8. I've now got new data that needs to use the same report but only has conditions 1, 2, and 3 and am getting "No such field in the field list". This makes sense being that 4,5,6,7 and 8 do not exist. My question is...
  4. EM2021

    Solved Update FY Start and End

    Bingo! Thanks so much.
  5. EM2021

    Solved Update FY Start and End

    Here are all the Subs under the Form code window. Let me know if this is not where I should be. Option Compare Database Private Sub cmdFYTDBUConstituentSummary_Click() If Not IsDate(Forms![Development Report Manager]!ReportDate.Value) Then MsgBox "Please pick a Report Date!", vbOKOnly...
  6. EM2021

    Solved Update FY Start and End

    I'm in the VBA code, but I'm not super familiar so maybe it's not jumping out at me. Any pointers? I've searched the 8/31/2021, "Report Date", "default" and I'm not finding anything. Additional comment, the Report Date was changing automatically throughout FY21. So this is a new issue as we've...
  7. EM2021

    Solved Update FY Start and End

    Sure thing. I hit save and it's still doing it. What. Am. I. Missing?!
  8. EM2021

    Solved Update FY Start and End

    It is blank.
  9. EM2021

    Solved Update FY Start and End

    It is defaulting to the last day in the FY End. That is what I need to figure out how to change.
  10. EM2021

    Solved Update FY Start and End

    Thanks, I agree. The VBA is where I get lost in this report. Where, specifically, would I put this?
  11. EM2021

    Solved Update FY Start and End

    Current Date would be ideal.
  12. EM2021

    Solved Update FY Start and End

    And I believe that its pulling with 8/31/2021 because that is the last option within the FY. So, my best guess with the note left behind is that I need to find where 9/1/2020 - 8/31/2021 is coded
  13. EM2021

    Solved Update FY Start and End

    Trying to replace and I get taken here through Debug:
  14. EM2021

    Solved Update FY Start and End

    Updating the Report Date does update the FY Start and End. But even after saving, when I reopen, the Report Date defaults back to 8/31/2021
  15. EM2021

    Solved Update FY Start and End

    Accidently marked solved. Definitely is not!
  16. EM2021

    Solved Update FY Start and End

    So it does update and work when I do this. However, when you close the form and reopen it, it defaults back. I need to have it open with today's date or at least 8/31/2022
  17. EM2021

    Solved Update FY Start and End

    Silly question. But... then I get a #Type mismatch.
  18. EM2021

    Solved Update FY Start and End

    I would like to make it that simple, for sure. Here is what I entered and what I get: What am I missing to make it stick at the dates in Design?
  19. EM2021

    Solved Update FY Start and End

    Report date is editable, but I'm having a hard time editing FY Start and End to reflect the new year
  20. EM2021

    Solved Update FY Start and End

    Hi there, I've inherited a report that is coded to pull specific dates (9/1/YY - 8/31/YY) It's our new year and I can't seem to figure out the notes on updating this. to pull 9/1/2021-8/31/2022. Notes are: "modify the code on the start and end dates by changing the option to Editable and...
Top Bottom