Table of Contents for a report i access 2007

This does still work in 2007. I have used the knowlege base solution quite successfully -- using a PDF printer. However, it still requires a manual click-through of the final report to populate the TOC.

One option around multiple clicks is to use the END key and/or click on the LAST RECORD button of the report to go to the last page of the report. This seems to function the same way as clicking through each individual page. It's a bit of a time-saver over clicking through page-by-page.

Using this manual method, My TOCs populate without fail using a couple quick keyboard sequences...1 - At the report preview -- hit the END key (or click on the LAST RECORD button), 2 - Once the last page shows -- hit the ESC key to close the report...then my automation takes over and the process repeats. The only other option that I have found involves using SENDKEYS which hasn't proven to be too reliable -- as the VBA code seems to operate asynchronously.

If anyone finds a truly automated solution (using Access), I'd be interested in learning about it myself...kind of goofey that this kludgey process has to be used.



Allen Browne wrote:

Not sure what else to suggest.
25-Feb-08

Not sure what else to suggest.

As you found, there's no way to get the TOC without printing or previewing
all pages. The simplest way to do that would be to print it to a printer
that doesn't actually use paper (such as a PDF driver.)

I doubt that trying to walk the pages will be productive.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dbqph" <dbqph RemoveThis @discussions.microsoft.com> wrote in message
news:09053411-920B-429A-A9E2-7D4746A33D55@microsoft.com...

Previous Posts In This Thread:

On Friday, February 08, 2008 5:13 PM
marlantaxpres wrote:

Table of Contents for a report i access 2007
I need help! I have created a Price list that is grouped by categories, and
im trying to make a table of contents page that gives me in what pages the
categories can be seen.

On Friday, February 08, 2008 5:53 PM
fredg wrote:

Re: Table of Contents for a report i access 2007
On Fri, 8 Feb 2008 14:13:00 -0800, marlantaxpress wrote:


I would assume this method for earlier versions should still work in
Access 2007.

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'

Then run a separate report, using the TOC table made by the first
report as it's recordsource, to print out just the Table of Contents.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Friday, February 08, 2008 9:25 PM
Allen Browne wrote:

Just in case you are not sure how to find the article Fred suggested, the link
Just in case you are not sure how to find the article Fred suggested, the
link is:
http://support.microsoft.com/kb/210269

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"fredg" <fgutkind RemoveThis @example.invalid> wrote in message
news:vc6t19inxqkp.1ht3axsnmd2j4.dlg@40tude.net...

On Sunday, February 24, 2008 7:49 PM
dbqp wrote:

Is there a method or process that will open/preview each page in a report so
Is there a method or process that will open/preview each page in a report so
that if I have a lengthy report (or if someone forgets to step through each
page) that the Table of Contents table will get all of its information
automatically?

dbqph

"Allen Browne" wrote:

On Monday, February 25, 2008 1:26 AM
Allen Browne wrote:

If you don't need the page numbers - just the list of topics - you could use a
If you don't need the page numbers - just the list of topics - you could use
a subreport bound to a query that gives just the headings.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"dbqph" <dbqph RemoveThis @discussions.microsoft.com> wrote in message
news:B5EB9911-837A-4A25-9308-4AF0A41C67A3@microsoft.com...

On Monday, February 25, 2008 10:02 AM
dbqp wrote:

Hi Allen,I am after the page numbers for a Table of Contents and was hoping to
Hi Allen,

I am after the page numbers for a Table of Contents and was hoping to find a
routine that utilizes http://support.microsoft.com/kb/210269 with the
following twists when a report is previewed or printed:

1. Initialize the TOC using the InitToc function.
2. Automatically loop through each page of the report to generate the
various page numbers (using Me.Page and Me.Pages as bounds). Perhaps
something in the UpdatePageNumber function?
3. Requery the TOC report (or sub-report)

I briefly looked at the GoToPage method which is sort of what I'm after but
it appears GoToPage is for Forms and I haven't located the code/command that
controls the Page selector control when a report is being previewed.

Any ideas for reports?

--
dbqpb

"Allen Browne" wrote:

On Monday, February 25, 2008 10:11 AM
Allen Browne wrote:

Not sure what else to suggest.
Not sure what else to suggest.

As you found, there's no way to get the TOC without printing or previewing
all pages. The simplest way to do that would be to print it to a printer
that doesn't actually use paper (such as a PDF driver.)

I doubt that trying to walk the pages will be productive.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dbqph" <dbqph RemoveThis @discussions.microsoft.com> wrote in message
news:09053411-920B-429A-A9E2-7D4746A33D55@microsoft.com...

On Monday, October 26, 2009 9:05 AM
Steve Pietra wrote:

Only manageable solution is still manual
This does still work in 2007. I have used the knowlege base solution quite successfully -- using a PDF printer. However, it still requires a manual click-through of the final report to populate the TOC.

One option around multiple clicks is to use the END key and/or click on the LAST RECORD button of the report to go to the last page of the report. This seems to function the same way as clicking through each individual page. It's a bit of a time-saver over clicking through page-by-page.

Using this manual method, My TOCs populate without fail using a couple quick keyboard sequences...1 - At the report preview -- hit the END key (or click on the LAST RECORD button), 2 - Once the last page shows -- hit the ESC key to close the report...then my automation takes over and the process repeats. The only other option that I have found involves using SENDKEYS which hasn't proven to be too reliable -- as the VBA code seems to operate asynchronously.

If anyone finds a truly automated solution (using Access), I'd be interested in learning about it myself...kind of goofey that this kludgey process has to be used.

EggHeadCafe - Software Developer Portal of Choice
Web Services - Server To Server With SOAP
http://www.eggheadcafe.com/tutorials/aspnet/b1ed6e8c-c5d9-418d-b0ae-21...1592d79

I'm not sure exactly what you are trying to do but if you are tring to make
a table of contents in a pdf file I stumbled across a solution that makes
bookmarks based on rules you supply. Example: if in your report you group
by somehing and you use a certain font/size (Arial 16) you can set a rule to
make bookmarks for all Arial 16 text. Using the novapdf printer driver.

Perhaps that would help,
Mark
RPT Software
http://www.rptsoftware.com

PS: It's only a function of the novapdf printer driver.

<Steve Pietra> wrote in message
news:200910269749jeff_gordon_24@hotmail.com...
> This does still work in 2007. I have used the knowlege base solution quite
> successfully -- using a PDF printer. However, it still requires a manual
> click-through of the final report to populate the TOC.
>
> One option around multiple clicks is to use the END key and/or click on
> the LAST RECORD button of the report to go to the last page of the report.
> This seems to function the same way as clicking through each individual
> page. It's a bit of a time-saver over clicking through page-by-page.
>
> Using this manual method, My TOCs populate without fail using a couple
> quick keyboard sequences...1 - At the report preview -- hit the END key
> (or click on the LAST RECORD button), 2 - Once the last page shows -- hit
> the ESC key to close the report...then my automation takes over and the
> process repeats. The only other option that I have found involves using
> SENDKEYS which hasn't proven to be too reliable -- as the VBA code seems
> to operate asynchronously.
>
> If anyone finds a truly automated solution (using Access), I'd be
> interested in learning about it myself...kind of goofey that this kludgey
> process has to be used.
>
>
>
> Allen Browne wrote:
>
> Not sure what else to suggest.
> 25-Feb-08
>
> Not sure what else to suggest.
>
> As you found, there's no way to get the TOC without printing or previewing
> all pages. The simplest way to do that would be to print it to a printer
> that doesn't actually use paper (such as a PDF driver.)
>
> I doubt that trying to walk the pages will be productive.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "dbqph" <dbqph DeleteThis @discussions.microsoft.com> wrote in message
> news:09053411-920B-429A-A9E2-7D4746A33D55@microsoft.com...
>
> Previous Posts In This Thread:
>
> On Friday, February 08, 2008 5:13 PM
> marlantaxpres wrote:
>
> Table of Contents for a report i access 2007
> I need help! I have created a Price list that is grouped by categories,
> and
> im trying to make a table of contents page that gives me in what pages the
> categories can be seen.
>
> On Friday, February 08, 2008 5:53 PM
> fredg wrote:
>
> Re: Table of Contents for a report i access 2007
> On Fri, 8 Feb 2008 14:13:00 -0800, marlantaxpress wrote:
>
>
> I would assume this method for earlier versions should still work in
> Access 2007.
>
> 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'
>
> Then run a separate report, using the TOC table made by the first
> report as it's recordsource, to print out just the Table of Contents.
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>
> On Friday, February 08, 2008 9:25 PM
> Allen Browne wrote:
>
> Just in case you are not sure how to find the article Fred suggested, the
> link
> Just in case you are not sure how to find the article Fred suggested, the
> link is:
> http://support.microsoft.com/kb/210269
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "fredg" <fgutkind DeleteThis @example.invalid> wrote in message
> news:vc6t19inxqkp.1ht3axsnmd2j4.dlg@40tude.net...
>
> On Sunday, February 24, 2008 7:49 PM
> dbqp wrote:
>
> Is there a method or process that will open/preview each page in a report
> so
> Is there a method or process that will open/preview each page in a report
> so
> that if I have a lengthy report (or if someone forgets to step through
> each
> page) that the Table of Contents table will get all of its information
> automatically?
>
> dbqph
>
> "Allen Browne" wrote:
>
> On Monday, February 25, 2008 1:26 AM
> Allen Browne wrote:
>
> If you don't need the page numbers - just the list of topics - you could
> use a
> If you don't need the page numbers - just the list of topics - you could
> use
> a subreport bound to a query that gives just the headings.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
> "dbqph" <dbqph DeleteThis @discussions.microsoft.com> wrote in message
> news:B5EB9911-837A-4A25-9308-4AF0A41C67A3@microsoft.com...
>
> On Monday, February 25, 2008 10:02 AM
> dbqp wrote:
>
> Hi Allen,I am after the page numbers for a Table of Contents and was
> hoping to
> Hi Allen,
>
> I am after the page numbers for a Table of Contents and was hoping to find
> a
> routine that utilizes http://support.microsoft.com/kb/210269 with the
> following twists when a report is previewed or printed:
>
> 1. Initialize the TOC using the InitToc function.
> 2. Automatically loop through each page of the report to generate the
> various page numbers (using Me.Page and Me.Pages as bounds). Perhaps
> something in the UpdatePageNumber function?
> 3. Requery the TOC report (or sub-report)
>
> I briefly looked at the GoToPage method which is sort of what I'm after
> but
> it appears GoToPage is for Forms and I haven't located the code/command
> that
> controls the Page selector control when a report is being previewed.
>
> Any ideas for reports?
>
> --
> dbqpb
>
> "Allen Browne" wrote:
>
> On Monday, February 25, 2008 10:11 AM
> Allen Browne wrote:
>
> Not sure what else to suggest.
> Not sure what else to suggest.
>
> As you found, there's no way to get the TOC without printing or previewing
> all pages. The simplest way to do that would be to print it to a printer
> that doesn't actually use paper (such as a PDF driver.)
>
> I doubt that trying to walk the pages will be productive.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "dbqph" <dbqph DeleteThis @discussions.microsoft.com> wrote in message
> news:09053411-920B-429A-A9E2-7D4746A33D55@microsoft.com...
>
> On Monday, October 26, 2009 9:05 AM
> Steve Pietra wrote:
>
> Only manageable solution is still manual
> This does still work in 2007. I have used the knowlege base solution quite
> successfully -- using a PDF printer. However, it still requires a manual
> click-through of the final report to populate the TOC.
>
> One option around multiple clicks is to use the END key and/or click on
> the LAST RECORD button of the report to go to the last page of the report.
> This seems to function the same way as clicking through each individual
> page. It's a bit of a time-saver over clicking through page-by-page.
>
> Using this manual method, My TOCs populate without fail using a couple
> quick keyboard sequences...1 - At the report preview -- hit the END key
> (or click on the LAST RECORD button), 2 - Once the last page shows -- hit
> the ESC key to close the report...then my automation takes over and the
> process repeats. The only other option that I have found involves using
> SENDKEYS which hasn't proven to be too reliable -- as the VBA code seems
> to operate asynchronously.
>
> If anyone finds a truly automated solution (using Access), I'd be
> interested in learning about it myself...kind of goofey that this kludgey
> process has to be used.
>
> EggHeadCafe - Software Developer Portal of Choice
> Web Services - Server To Server With SOAP
> http://www.eggheadcafe.com/tutorials/aspnet/b1ed6e8c-c5d9-418d-b0ae-21...1592d79