Web Development

Ask something
Discussion Locked

Access97 Continuing Groups,KB Art.Q88156

0 helpful
3 replies

by learneverything

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

HELP!!! I'm trying to use the example for Northwind given by the above Knowledge Base article. I've double checked that I've done everything it asked and I'm getting Run-time error 94: Invalid use of Null.

I did notice that although I typed the OnPrint properties in the page header and footer as stated in the article. Access changed (Report)to ([Report]) in both cases.
Can someone help?? The debugger points to the second line of the following function.

Function SetGlobalVar(InReportAs Report)
CurrentGroupVal = InReport!SetGroupVal
End Function

I'm not sure that this example will give me what I need anyhow. In my report, there are 5 groups and 5 additional sort orders. If everything for the 3rd group continues on thenext page, the 2nd and 3rd group headers need to repeat with (continued) beneath the 3rd one. I'll be grateful for any guidance. THANKS.

3 replies

by grybyx

Check out the WillContinue property. Using your KB article as a guide, I went on my own like this:

1) On the right-hand side of the page footer, create a label called ContinuedLabel with a caption such as "continued...".

2) Set the page footer's OnPrintProperty to

=SetContinuedLabel(Report)

3) Give the group footer you want to check a meaningful name, such as "MyGroupFooter".

4) Re-code the SetContinuedLabel function like so:

Function SetContinuedLabel(InReport As Report) If InReport.Page <> 1 Then
InReport!ContinuedLabel.Visible = _
InReport.MyGroupFooter.WillContinue
End If
End Function

Now, whenever my group will continue on the next page, I see "continued..." at the bottom-right corner of the page.

Let me know if this works for you.

by learneverything

Jeff, thank you for your valiant and tireless efforts. I still have some tweaking to do. But you got me much further in the process than I could have alone.

This discussion is closed to new replies.