Solved

Subreport within Subreport Crashes Access

Posted on 2008-06-16
9
551 Views
Last Modified: 2012-05-05
Hi,

I am trying to produce quite a complex Access report that will require 3 levels of subreports.

When placing a subreport within a subreport, I get a Access crash!

Does anyone know why this is occurring?

This is quite urgent
0
Comment
Question by:jset_expert
  • 4
  • 3
9 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21800177
Hi jset_expert,

Are you using Access 2003 SP3?

Gary
0
 
LVL 1

Author Comment

by:jset_expert
ID: 21800201
Im using access 2003 (11.5614.5606)

Not sure of the level of service pack, does not mention anything

Do I need to update, if so, do I just use the Windows update (I have vista)
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21800220
0
 
LVL 1

Author Comment

by:jset_expert
ID: 21828476
updates access to SP3....still no success.

Fails every time!
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 46

Expert Comment

by:tbsgadi
ID: 21829279
Try decompiling & compacting
http://www.granite.ab.ca/access/decompile.htm
0
 
LVL 1

Author Comment

by:jset_expert
ID: 21835889
I got around this by creating the subreport within the subreport separately.

Then I created the subreport in the main report and just referenced the created report. Worked a treat!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21838214
Great!
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22575894
PAQed with points refunded (350)

Computer101
EE Admin
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now