?
Solved

Subreport within Subreport Crashes Access

Posted on 2008-06-16
9
Medium Priority
?
556 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
[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
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 1

Author Comment

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

Fails every time!
0
 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

770 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