Search results

  1. C

    Check Box IIF Statement

    so =IIF([cbxPC],[PremierCourseCredit]=[Award Amount], "0") The code turns red.
  2. C

    Check Box IIF Statement

    I have a check box (cbxPC) I want an iff statement when true, then [PremierCourseCredit]=[Award Amount] if false then [PremierCourseCredit]=0 Not sure how to write it or where to put the code. Thanks
  3. C

    Save reports sent out

    I have students who have applied for scholarships. When we send an approval letter, is there a way save it under their profile? Maybe a macro that uploads it as an attachment? Or any other ideas?
  4. C

    Update Query

    Would a find and replace be a better option? I have my payment table to have the invoice number and check number for each payment. My datasheet form I have it filtered to the invoice number. I can run a code??? to find blanks and replace with what is in unboud field?
  5. C

    Update Query

    I am new to update queries and need some guidance. I have a form that I will filter by Invoice Number I have an unboud field that I can type in the check number. Sometimes I have over 50 records that need the check number added. I would like to type in the check number and it update the...
  6. C

    Solved Open Form Where Condition Text Field

    Exactly what I was looking for. Thanks
  7. C

    Solved Open Form Where Condition Text Field

    I have a student ID that looks like this AB123456 I want to open a form based on a form I have a combo box with a macro. I am stumpted on the where condition because it is a text field. =" [Student ID] =" & [Student ID]
  8. C

    #size error on print preview

    I figured it out. I needed to add Clng to the begining.
  9. C

    #size error on print preview

    That did not work. I did it to be 0 if the filed is null. Becasue I don't have anything invoiced yet, the report view shows $0, but the print view says #Error. When I try =Nz([qryRequested Course_CrosstabFY23 subreport].[Report]![Text17],0) I get #Size! When I do =[qryRequested...
  10. C

    #size error on print preview

    Text117 is in subform and the control source I have: =Sum([PaymentAmount]) the format is set to Currency
  11. C

    #size error on print preview

    Currency
  12. C

    #size error on print preview

    I have this in my report but when I go print preview I get the #size error. =[qryRequested Course_CrosstabFY23 subreport].[Report]![Text17] I have tried =NZ([qryRequested Course_CrosstabFY23 subreport].[Report]![Text17],0)) and still get it. Can somone guide me in what other options I have...
  13. C

    Filter on Load

    That worked! Thanks so much!
  14. C

    Filter on Load

    Ah, that makes sense. It was working with that in there. I'll try again.
  15. C

    Filter on Load

    Thank you I am getting closer. I now have this. How do I filter back to the filter on load? My filter on load is 10/1/22-9/30/23 when I use the code below it works perfectly and unfilters. When check box is clicked again, I want it to go back. to the filter on load. If me.YourCheckbox = False...
  16. C

    If statments

    I want this to run as an after update. So once I add in my amounts, once the remaining is 0, then the status field switches to "Funds Exhausted"
  17. C

    If statments

    I have a field [Remaining] I would like to do a macro where when [Remaining]=0, [Status], "Funds Exhausted" Or do I do a condional format?
  18. C

    Filter on Load

    Can you guide me on how to do this part? I have the check box and the default value is 0 (unchecked) As for the after update, how do I do that? Macro or Code? box name: ckbxSeeAll When checked-I want to clear the filter on load. Unchecked
  19. C

    Filter on Load

    After trial and error this finally worked. [qryRequested Course_View].[Completion Time] Between #10/1/2022# And #9/30/2023#
  20. C

    Filter on Load

    Nope, still getting all the records.
Back
Top Bottom