Is it possible to I create a table of contents in an access report

K

kris1616

I have a lengthy report for which I need to create a table of contents. I
know that I would need to do a sub report, but is there a way to create a
table of contents in Access?
 
F

fredg

I have a lengthy report for which I need to create a table of contents. I
know that I would need to do a sub report, but is there a way to create a
table of contents in Access?
Click to expand...

What version of Access are you using?
Here is a method for Access 2000.
See Microsoft KnowledgeBase article:
210269 'ACC2000: How to Create a Table of Contents or Index for a
Report'

For Access 97 and older:
131588 'ACC: How to Create a Table of Contents or Index for a Report'

You must actually step through each page of the report (in preview, or
by actually printing it).

Then run a separate report, using the TOC table made by the first
report, to print out just the Table of Contents.
 
P

PC Datasheet

Yes, go to the MS KnowledgeBase; there's an article there on how to do it.
Sorry I don't know the number. Also check www.mvps.org/access and go to the
reports section to see if there is anything there.
 
H

holly1

Well, this is a very old thread, but maybe it can be resurrected. I have
tried the instructions given in Microsoft's post 210269 with no luck. It does
not work with my file and I have Access 2007. Any suggestions?
 
S

stef

Just wondered if you had any luck with this as I struck the same problem with
Access 2007
 
M

Mark Andrews

Not sure if this is what you want but you could use novpdf printer driver
to create bookmarks in a pdf file which serve as a table of contents some
what.
It uses rules you define such as take all group heading that are arial size
14 and turn them into
bookmarks.

http://www.novapdf.com/buy-now.php

You need to get the:

novaPDF Pro Desktop- $49.95

for this to work.

HTH,

Mark Andrews

RPT Software

http://www.rptsoftware.com
 
C

Chris Patton

Mark, do you have a product that will split a PDF into files based on the
BookMark (and name them by bookmark)? I would like to print a very large
Access report to PDF and then split it into a large number of PDF's based on
Bookmark?

novpdf has me half way there.
 
S

Steve

Hi Chris,

Why don't you save your entire report to PDF in one process then save the
parts of the report to separate smaller PDFs rather than trying to split up
your large PDF into smaller PDFs? Saving the parts of the report to separate
smaller PDFs should be relatively easy; all that needs done is to make
appropriate parts of the report not visible when you save each PDF.

Steve
(e-mail address removed)
 
M

Mark Andrews

Sorry for the late reply. I don't have a product that does that. I know
there are third party products that merge and split pdf files (not sure if
they do it in that manner)?

I would recommend the approach Steve mentioned to have Access control what
gets printed to a pdf.

If you email me more details I might be able to figure out something better.
As you see I don't check newsgroups every day and missed this latest reply
by you.

Mark
RPT Software
http://www.rptsoftware.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy table of contents to a new doc 0
Proposal template with removable sections 0
Tagging Misspell Words with "##" 0
Content Control Box Issue - Please Help! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding Heading to Table of Contents after a column break 1
List all tables, including document structure 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top