Search results

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

I have searched all over on this and I can't find anything, though I am sure it must be a simple problem. When I print my report it appears shrunken in the upper left corner of the paper (I mean tiny!). On print preview there is no problem--it appears full-size and accurate. Does anyone know...

Pat, I'm confused. The only field that is a checkbox is SelectTest. That was the one I was worried would need to be changed to "True" instead of "Yes" in my code. Is that not a necessary or accurate change? I do think I understand the difference between not true and null and false. I...

Thanks for your help Pat. One more question as I'm still learning this stuff... is my code wrong then? Instead of "Me.SelectTest = Yes" should I be using "True"? Wouldn't that code still work then (provided I use the right word, Yes or True), because whether it's null or False, it still...

still no luck I am still having the same problem. Perhaps because of the checkbox?? If the checkbox is checked, then those other fields should be populated. If it is not checked then there is no need. Pat, are you saying the problem is in the difference between not checking and unchecking...

I have a form with a test list. Each test is a record with a yes/no checkbox, and controls for testdate and examiner. I don't want the user to be able to exit a record if the yes box is checked and either the testdate or examiner fields are blank. The code I am using is: If...