Recent content by CarlyS

You're the best! Thank you so much for seeing this through. Carly

That would be wonderful. Thank you for your help. Here it is...

Nope. That didn't do it.

I took that out. Still doesn't work. I also tried this, which I think says basically the same thing. This also didn't work. Any ideas? Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer) If IsNull(Me.DateCompleted) Then If Me.ItemStatus = "c" Then...

Ok, yes, they were both controls, but I found that there was a typo in one of them. Now, the report opens, but the fill color does not change. It's like there's no code at all. What am I missing?

No--Nothing said missing. Any other reasons that might happen?

How would I know if I had "missing or bogus references"? I have kept this pretty simple, so I would think not, but I'm not sure what that means.

ItemStatus is a textbox. SignalBox is a rectangle. The error highlights the very first instance of ItemStatus, saying that it is not found. Here is what the code looks like now: Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer) If Me.ItemStatus = "c" And...

Thanks for heading off that problem before I got to it! Still though, no luck with the "method or data member not found" error. Any ideas?

that didn't do it... Thanks for the reply, but unfortunately, I still get the same error. Any other ideas?

I am trying to set the back color of a rectangle (called SignalBox) on a report. The color depends on the value of another field, ItemStatus, which will have a value of a,b, or c. Can someone look at this code and tell me why I get this error? The report is based on a query. ItemStatus is a...

got it... In the effects tab of print properties it was set to a percentage of the actual size. Just had to change it back to 100%.

that was it! Fabulous--Thank you so much!

I have a MainQuery with the following fields: ID-(the patient's ID) Score ItemID I am trying to get the highest score for each patient and be able to identify which item was their high score, so basically I want to end up with the following query results: ID (Patient'sMax)Score ItemID To do...

Well, I can print other reports and other documents with no problems. I only print to that printer from my laptop. It is a network printer at work. But this is the only document that is having a problem. Does that shed any light? Thanks! Carly