Solved

Database Subform not printing all the data

Posted on 2013-05-24
2
302 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
[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
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 39195208
"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
ID: 39195815
sorry I thought I connected the database
CASpReports-EPE-Rvw.accdb
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

728 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