Table of Contents in Access

  • Thread starter Thread starter Guest
  • Start date Start date
Does anyone know of a way to create a table of contents for a report 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'
 
I am running Access 2003. I read the article you suggested and created the
module as per its instructions. For some reason my "Table of Contents"
folder did not update.

I have the appication and database split so one person I substitute
"db.OpenDynaset" instead of "db.OpenRecordSet" when trying to open the Table
of Contents table.

The original line per the article is

Set TocTable = db.OpenRecordSet ("Table of Contents", dbOpenTable)

Quite honestly I am new at this so I don't know if the table isn't updating
because it is not opening or the Function UpdateToc is not working. Function
UpdateToc is addressed in the article you reference.

I'm not sure where to look next.
 
Back
Top