Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Database Subform not printing all the data

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

885 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