?
Solved

Subreport within Subreport Crashes Access

Posted on 2008-06-16
9
Medium Priority
?
572 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

568 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