Recent content by chapmajm

  1. C

    Is it possible to delete the last comma using Trim?

    Hi Wayne, Thank you so much for all of your help. It worked. Actually though, it wasn't working at first and I couldn't figure out why, but it was because my trailing characters were a "," and a "space", so when I include the ", " and -2 it works great! Thanks again.
  2. C

    Combine TWO IIF(IsNull) Expressions into one control

    It did work. I'm so relieved. Thank you.
  3. C

    Combine TWO IIF(IsNull) Expressions into one control

    Ah, I think the AND is null expression will work. Thank you.
  4. C

    Combine TWO IIF(IsNull) Expressions into one control

    Is it possible to combine two IIf(IsNull) Expressions into one control on a report in design view or in a query without having to do concatenating and looping and what not? =IIf(IsNull([Constitutional]),"CONSTITUTIONAL SYMPTOMS: None ",("CONSTITUTIONAL SYMPTOMS: ") & " " & [Constitutional]) I...
  5. C

    Is it possible to delete the last comma using Trim?

    BTW- I'm not getting report outcomes like Q1,,,Q7,Q8,,Q11. Can I use just the end of your code that simply removes the last comma and that's it?
  6. C

    Is it possible to delete the last comma using Trim?

    Oh, I understand. I haven't used Modules yet. I always think VB first. woops. I will try this tomorrow. If I start tonight I'll keep myself up all night getting all into it. Time flies when you're stumped and using trial and error on everything you're doing in your database, right? But...
  7. C

    Help adding "text" (ENTER) and more text using VB

    Hey Guy, Well, it worked. Thanks for your help. It came in very handy. I like using the vbCrLf. You helped me out a lot. It's amazing how much smarter you people are making me. -Jenny
  8. C

    Combo Box creating multiple unwanted pages on a report

    My Solution If anybody in the future ever has this problem, here is the answer. Private Sub Command90_Click() On Error GoTo Err_ConsultReport_Click Dim Counter As Integer Counter = 0 DoCmd.SetWarnings False DoCmd.OpenQuery "que-DeleteRecordsFrom-TempConsultInfoTable", acViewNormal...
  9. C

    Help w/ check box that can add additional text to field, not just replace text.

    It works! Woo Hoo! Brilliant! Thank you! I need to do this because I've created a database simply to replace a medical transcription service. The doctor clicks a check box in my "VisitPlan" memo field. So, if he has multiple plans for the patient... he needs to check multiple boxes. I.e...
  10. C

    Help w/ check box that can add additional text to field, not just replace text.

    Hello, I need help adding text to a field by using a check box. Not just replacing the current text with the text I coded in. Private Sub CheckBoxName_AfterUpdate() If Me![CheckBoxName].Value = False Then Me![FieldName] = Null If Me![CheckBoxName].Value = True Then Me![FieldName] = "text"...
  11. C

    Is it possible to delete the last comma using Trim?

    I'm still trying to fix my problem. Where do I put your code? Is it possible to use it in conditional formatting on the report level? Or do I still need to create strings in my query first?
  12. C

    Is it possible to delete the last comma using Trim?

    Thank you. I used trim to also remove fields that were blank. So I will try this code tomorrow at work.... My appreciation. :) -Jenny
  13. C

    Help adding "text" (ENTER) and more text using VB

    I see now. Okay, thanks! I will give it a shot and get back to you. I appreciate your help.
  14. C

    Help adding "text" (ENTER) and more text using VB

    "Your text" & vbCrLf & "more text" & Chr(13) & Chr(10) Hi! Thanks for replying. So does the vbCrLf make a new line or something? What does the Chr(13) & Chr(10) do?
  15. C

    Is it possible to delete the last comma using Trim?

    Hi! Thanks for replying. I tried copying and pasting your expression and it didn't work. Did I miss something? =IIf(IsNull([Q1]),[Q2],([Q3] & ", ")) -Jenny
See more
Back
Top Bottom