Can I build a Table of Contents listing all records like a TOC in

[Guest]

Can I build a Table of Contents list, so that it prints before I print my
database records? I'm working on a murder investigation and have a list of
witnesses. My report prints a page for each witness in the database. I
would like to set up Access to print a table on contents with page numbers
like MS Word will do. Is it possible?

Thanks

 

[M.L. Sco Scofield]

You don't mention what version of Access you are using. (Working on a murder
investigation, I'd expect you to be *very* detail oriented.

Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210269.

Even though it (and the sample database - the link under the "Summary"
heading) is in Access 2000, the information should work just fine in Access
2002 and 2003.

If you are using Access 97 or earlier, take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;131588.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Guest]

Thanks for the info, however, I am having difficulty with a run-time error
3800, 'Description' is not an index in this table; both in the sample program
and my witness table. I'm using Access 2003, but the database format is
Access 2000.

 

[M.L. Sco Scofield]

I just downloaded another copy of the sample database from the link I sent
you and it works just fine in Access 2003.

It sounds like you might not have the latest service packs installed for
Office 2003 and Jet 4.0.

Take a look at http://support.microsoft.com/?scid=kb;en-us;303528 and
http://support.microsoft.com/?scid=kb;en-us;239114.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com