Is it possible to I create a table of contents in an acces..

kris1616 · External Since: Jan 27, 2005 Posts: 6

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?

fredg · External Since: Jan 30, 2004 Posts: 3580

On Tue, 25 Jan 2005 14:07:03 -0800, kris1616 wrote:

> 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?

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.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

PC Datasheet · External Since: Jan 03, 2004 Posts: 889

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 <a style='text-decoration: underline;' href="http://www.mvps.org/access" target="_blank">www.mvps.org/access</a> and go to the
reports section to see if there is anything there.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource.TakeThisOut@pcdatasheet.com
<a style='text-decoration: underline;' href="http://www.pcdatasheet.com" target="_blank">www.pcdatasheet.com</a>

"kris1616" <kris1616.TakeThisOut@discussions.microsoft.com> wrote in message
news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
> 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?

kris1616 · External Since: Jan 27, 2005 Posts: 6

Thank you for referring me to that article. This is exactly what I needed.

stef · External Since: Jul 14, 2009 Posts: 1

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

"holly1" wrote:

> 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?
>
> "PC Datasheet" wrote:
>
> > 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.
> >
> >
> > --
> > PC Datasheet
> > Your Resource For Help With Access, Excel And Word Applications
> > resource.TakeThisOut@pcdatasheet.com
> > www.pcdatasheet.com
> >
> >
> >
> >
> > "kris1616" <kris1616.TakeThisOut@discussions.microsoft.com> wrote in message
> > news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
> > > 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?
> >
> >
> >

Mark Andrews · External Since: Oct 19, 2003 Posts: 46

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

"stef" <stef DeleteThis @discussions.microsoft.com> wrote in message
news:C05022C8-787B-48BE-AED4-2440391649A7@microsoft.com...
> Just wondered if you had any luck with this as I struck the same problem
> with
> Access 2007
>
> "holly1" wrote:
>
>> 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?
>>
>> "PC Datasheet" wrote:
>>
>> > 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.
>> >
>> >
>> > --
>> > PC Datasheet
>> > Your Resource For Help With Access, Excel And Word Applications
>> > resource DeleteThis @pcdatasheet.com
>> > www.pcdatasheet.com
>> >
>> >
>> >
>> >
>> > "kris1616" <kris1616 DeleteThis @discussions.microsoft.com> wrote in message
>> > news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
>> > > 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?
>> >
>> >
>> >

Chris Patton · External Since: Sep 09, 2009 Posts: 1

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.

"Mark Andrews" wrote:

> 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
>
>
>
>
>
> "stef" <stef DeleteThis @discussions.microsoft.com> wrote in message
> news:C05022C8-787B-48BE-AED4-2440391649A7@microsoft.com...
> > Just wondered if you had any luck with this as I struck the same problem
> > with
> > Access 2007
> >
> > "holly1" wrote:
> >
> >> 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?
> >>
> >> "PC Datasheet" wrote:
> >>
> >> > 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.
> >> >
> >> >
> >> > --
> >> > PC Datasheet
> >> > Your Resource For Help With Access, Excel And Word Applications
> >> > resource DeleteThis @pcdatasheet.com
> >> > www.pcdatasheet.com
> >> >
> >> >
> >> >
> >> >
> >> > "kris1616" <kris1616 DeleteThis @discussions.microsoft.com> wrote in message
> >> > news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
> >> > > 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?
> >> >
> >> >
> >> >
>
>
>

Steve · External Since: Aug 04, 2009 Posts: 47

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
santus.DeleteThis@penn.com

"Chris Patton" <Chris Patton.DeleteThis@discussions.microsoft.com> wrote in message
news:AEB5B708-1B3A-42DB-B26C-87B656238A35@microsoft.com...
> 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.
>
> "Mark Andrews" wrote:
>
>> 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
>>
>>
>>
>>
>>
>> "stef" <stef.DeleteThis@discussions.microsoft.com> wrote in message
>> news:C05022C8-787B-48BE-AED4-2440391649A7@microsoft.com...
>> > Just wondered if you had any luck with this as I struck the same
>> > problem
>> > with
>> > Access 2007
>> >
>> > "holly1" wrote:
>> >
>> >> 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?
>> >>
>> >> "PC Datasheet" wrote:
>> >>
>> >> > 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.
>> >> >
>> >> >
>> >> > --
>> >> > PC Datasheet
>> >> > Your Resource For Help With Access, Excel And Word Applications
>> >> > resource.DeleteThis@pcdatasheet.com
>> >> > www.pcdatasheet.com
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > "kris1616" <kris1616.DeleteThis@discussions.microsoft.com> wrote in message
>> >> > news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
>> >> > > 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?
>> >> >
>> >> >
>> >> >
>>
>>
>>

Mark Andrews · External Since: Oct 19, 2003 Posts: 46

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

"Chris Patton" <Chris Patton RemoveThis @discussions.microsoft.com> wrote in message
news:AEB5B708-1B3A-42DB-B26C-87B656238A35@microsoft.com...
> 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.
>
> "Mark Andrews" wrote:
>
>> 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
>>
>>
>>
>>
>>
>> "stef" <stef RemoveThis @discussions.microsoft.com> wrote in message
>> news:C05022C8-787B-48BE-AED4-2440391649A7@microsoft.com...
>> > Just wondered if you had any luck with this as I struck the same
>> > problem
>> > with
>> > Access 2007
>> >
>> > "holly1" wrote:
>> >
>> >> 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?
>> >>
>> >> "PC Datasheet" wrote:
>> >>
>> >> > 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.
>> >> >
>> >> >
>> >> > --
>> >> > PC Datasheet
>> >> > Your Resource For Help With Access, Excel And Word Applications
>> >> > resource RemoveThis @pcdatasheet.com
>> >> > www.pcdatasheet.com
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > "kris1616" <kris1616 RemoveThis @discussions.microsoft.com> wrote in message
>> >> > news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
>> >> > > 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?
>> >> >
>> >> >
>> >> >
>>
>>
>>

Mark Andrews · External Since: Oct 19, 2003 Posts: 46

or http://www.nitropdf.com/professional/support/manual/Split_PDF_files.htm

"Mark Andrews" <mandrewsNOSPAM RemoveThis @rptsoftware.com> wrote in message
news:%234$pBfzSKHA.1372@TK2MSFTNGP02.phx.gbl...
> 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
>
>
> "Chris Patton" <Chris Patton RemoveThis @discussions.microsoft.com> wrote in message
> news:AEB5B708-1B3A-42DB-B26C-87B656238A35@microsoft.com...
>> 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.
>>
>> "Mark Andrews" wrote:
>>
>>> 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
>>>
>>>
>>>
>>>
>>>
>>> "stef" <stef RemoveThis @discussions.microsoft.com> wrote in message
>>> news:C05022C8-787B-48BE-AED4-2440391649A7@microsoft.com...
>>> > Just wondered if you had any luck with this as I struck the same
>>> > problem
>>> > with
>>> > Access 2007
>>> >
>>> > "holly1" wrote:
>>> >
>>> >> 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?
>>> >>
>>> >> "PC Datasheet" wrote:
>>> >>
>>> >> > 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.
>>> >> >
>>> >> >
>>> >> > --
>>> >> > PC Datasheet
>>> >> > Your Resource For Help With Access, Excel And Word Applications
>>> >> > resource RemoveThis @pcdatasheet.com
>>> >> > www.pcdatasheet.com
>>> >> >
>>> >> >
>>> >> >
>>> >> >
>>> >> > "kris1616" <kris1616 RemoveThis @discussions.microsoft.com> wrote in message
>>> >> > news:9205DD1F-63B1-47FC-A333-9183ADE9FD90@microsoft.com...
>>> >> > > 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?
>>> >> >
>>> >> >
>>> >> >
>>>
>>>
>>>
>
>