Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Database Subform not printing all the data

Posted on 2013-05-24
2
Medium Priority
?
311 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 2000 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

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.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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 …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

688 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