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
Reply to group, rather than allenbrowne at mvps dot org.
Previous Posts In This Thread:
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.
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
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
Reply to group, rather than allenbrowne at mvps dot org.
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
:
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
Reply to group, rather than allenbrowne at mvps dot org.
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
:
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
Reply to group, rather than allenbrowne at mvps dot org.
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/tutorial...0ae-216f61592d79/web-services--server-to.aspx