Search results

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.

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

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

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...

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?

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...

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

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...

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...

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"...

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?

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

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

"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?

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

Hi all, I have check boxes that automatically input text into fields on forms. I use this code... Private Sub Check88_AfterUpdate() If Me![Check88].Value = False Then Me![VisitHistory] = Null If Me![Check88].Value = True Then Me![VisitHistory] = "Additional text." DoCmd.RunCommand...

Hi, Does anybody know how I would get rid of the last comma in the following expression? Pardon me if I don't use the correct terminology but, I'm creating a report where I'm combining a bunch of fields separated by commas. But the problem is that if I don't populate the last field in the...

Oh my gosh. I'm so frustrated with this now. I'm going call the geek squad. I believe my relationships have errors. Your recommendations were way over my head. Thanks for all your help.

Ok. I'm going to give it a shot! Thanks. I'll let you know how it turns out. -Jenny

Thanks for your help, but I tried a subreport and the records don't show up on the report. Even though the records show up on the report if I run the subreport alone. I also tried the requery thing, but it didn't work either. Ugh, this is hard. I've tried help, but that's hard because I...