Solved

Database Subform not printing all the data

Posted on 2013-05-24
2
288 Views
Last Modified: 2013-07-01
I am using the attached database to generate a report and wanted to add a table of contents at the front.

I could not make that work, so I added an index at the back using a sub form:

CASp_ReportTableOfContentsRpt02172013

The data for the subform is added to the table as the report prints, filling all the "elements" and their associated page numbers.

The process to populate the table works fine, but the CASp_ReportTableOfContentsRpt02172013 subform only prints a portion of the data. I'm not sure why that is happening. I've tried re-applying the data query and requerying the CASp_ReportTableOfContentsRpt02172013 subform but neither of these processes work.

Can you offer any suggestions? database is attached.
0
Comment
Question by:rogerdjr
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
"I could not make that work,"
Not clear on what exactly this mean...?
Your database was not attached...

So is your question how to create a table of contents?
If so, see here:
http://support.microsoft.com/kb/131588
0
 

Author Comment

by:rogerdjr
Comment Utility
sorry I thought I connected the database
CASpReports-EPE-Rvw.accdb
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

11 Experts available now in Live!

Get 1:1 Help Now