[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Subreport within Subreport Crashes Access

Posted on 2008-06-16
9
Medium Priority
?
568 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
8 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

590 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