Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Subreport within Subreport Crashes Access

Posted on 2008-06-16
9
Medium Priority
?
560 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

610 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