Recent content by eddy556

Okay how would I search through one of them looking for a certain module etc when there could be more than one

I have a report with module names on it. How would I loop through these names to check for a certain module)? Thanks

You're the king!

Am I right in thinking Case Is >= 60 < 69 Me.txtClassification.value = "Merit" Exit Function Tests if the case is between 60-69?

Thanks thats perfect

Hey, I know I'm probably being a bit dumb here but I've got a problem trying to test if a number is between two other numbers. This is what I've got: If (assignment >= 40 < 50) Or (exam >= 40 < 50) Then If (Average > 50) Then MsgBox ("Compensated Pass") Exit...

Yes that what I mean - what code do I write within the report to get at those details?

How do I access the values in a report using VBA? For example using VBA how would I see whether a certain value has appeared on the report? Thanks

Hmm well with the OnFormat it execute loads of times?

What event would I use to run some code when a report opens in order to populate a textbox? Thanks