Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Course Of The Month
2 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access Report error
Posted on 2013-06-28
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active today
Paste this function into a standard module:
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
- Phishing
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security, Security
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Suggested Courses
Course of the Month2 days, 10 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.