Recent content by Jennacat

Never mind. I figured it out. :) I'm a bit rusty.........

I'm sorry, but that isn't what I'm going for. Here is what I want it to look like: Question: [QuestionNum] [Text6] Where QuestionNum = 1 and Text6 = What did you value most? I have coding that looks like this: If Me.QuestionNum = "1" Then Me.Text6 = "What did you value most:" End If If...

Thanks for the help!

This is going to sound dumb and I should know the answer but how do I do that?

Here's how I want it to look: Section: C Facility Comment Comment Section: D Care Provider Comment Comment So that text box is always in the same spot. The report is grouped by section so all the comments from that section are together. I tried putting different textboxes...

Ok, now another problem came up. It wants to put what's for sectionName H ("Overall Assessment") in the box for C ("Facility") If Me.SectionName = "C" Then Me.Text15 = "Facility" End If If Me.SectionName = "H" Then Me.Text15 = "Overall Assessment" End If

Oops, I missed the "" around A. Now it works. It just had a problem with that name. Thanks!

I'm sorry. I can't spell today. I meant mean. Anyways, I tried changing the name to SectionName and now I don't get an error but I also don't get anything. Here is a bit of my code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.SectionName = C Then Me.Text15 =...

I've tried that. The problem seems to come from me.section = A. I've tried it with quotation marks and without. It doesn't seem to like letters. I get an error message stating "Compile error: Argument not optional" and it highlights section. What does that me and how do I fix it?

Quick question: I have a report that lists patient comments based on different areas. The areas are entered into the database as either 1, 2 , 3, etc. or A, B, C, etc. These correspond to a section title: "Scheduling you visit"; Registration"; "Facility" and so on. On my report I have a text...

I need to know how to do this too!! Anybody have a solution? Except I'm using Access 2000 and Crystal Reports 2008.

Sorry about that. CR is Crystal Reports. I should have been more clear. We are having problems with Crystal Reports 2008. Every time we connect to the Access Database it closes Crystal Reports. It was suggested that it was a configuration issue, but i have no idea how to fix it.

Hello! Quick question: Why does CR close every time I try to connect to my Access DB? It will let me find my DB and click Finish, then it thinks and closes out of the whole program. Any ideas as to why???????????????????? Thanks for your help!

I have no idea. I bought the thing about a month ago so it's new. How do I find out what service pack I have, if any? I was looking at the Error List and it was empty. I found the error logs, but have no idea how to read them.

I'm still not getting anywhere with these dang reports. Is there anybody out there that has worked with SSRS and an Access DB? I just can't seem to figure out what I'm doing wrong................