The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
MS Access Report error
HI
I have an Access Report that contains a sub report. The main form has control that references a total box on the sub report. This all works fine until the sub report contains no data and then the control that references it on the main form display #error.
How can I get around this?
Many thanks
I have an Access Report that contains a sub report. The main form has control that references a total box on the sub report. This all works fine until the sub report contains no data and then the control that references it on the main form display #error.
How can I get around this?
Many thanks
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Function AvoidError(n As Variant, varReplaceWith As Variant)
10 On Error GoTo AvoidError_Error
20 AvoidError = Nz(n, varReplaceWith)
AvoidError_Exit:
30 Exit Function
AvoidError_Error:
40 AvoidError = varReplaceWith
50 Resume AvoidError_Exit
End Function
and then change the reference in your report to:
=AvoidError(<subreport reference here>, "N/A")
Jim.