Re: Word Index entry limitations?

Thanks for your quick reply, Jay. The answer to (1) kind of rules out using
the Word index program as a solution to (2), though. There are over 150,000
{XE} entries in just the first 23 volumes. Upgrading to 2007 is not an option
right now.

Plan B is to read the generated Word indexes into a db table with fields for
surname, firstname, see_names, and page(s). The volume number will be added
manually for each volume index file. My books are used to research people
mentioned in old family Bibles, wills, etc., so only the names are indexed;
surnames are topics, first names are subtopics. After I manually add the
volume number, I'll append the table to a master table that contains all
volumes. By sorting the resulting master table I can easily generate an index
like this:

SMITH
John Vol 2:1
John Vol 15:14-16, 3

but I need to somehow merge all the John Smiths into one line, something
like this:

SMITH
John Vol 2:1; Vol 15:14-16, 3

I can do that, but I think there may be a better solution than writing code
to search the table for all the volumes and page numbers for Smith, John,
output that record to another table, skip to the next record after the last
Smith, John (the names will be sorted alphabetically already) and repeat the
process for all 200,000 entries.

Where should I move this topic to find help such as this? I have VFP8, and
Access, as part of Office Pro 2003, and can use the VBA that comes with it.

Thanks again.




"Jay Freedman" wrote:

Deidre wrote:
1. What is the maximum number of index entries allowed in a Word 2003
document?

2. I abstract historical microfilm to book form. Each volume - about
200 pgs - has its own index. I am up to Volume 24 and some customers
would like an index that spans all volumes. I see from other posts
that a multi-document approach is out.

I would like to publish this compiled index on my web site, also. I
was an applications programmer for 20 years, so I can use most of the
studio tools, but its been awhile. I could use some help, especially
with the newer 3
letter words.

Thank you

I don't see any documented limit specifically on the number of index entries
per document. According to http://support.microsoft.com/?kbid=211489, Word
versions up to 2003 are limited to 32000 fields of any kind per document,
while in Word 2007 that's raised to over 2 billion. It doesn't say whether
the INDEX field that displays the entries has some smaller limit.

A multi-document approach is not necessarily out of contention. If you
create a separate document and insert RD fields in it to point to the
others, and then an INDEX field, it will pull entries from all the
referenced documents. You would have to manage the page number starts in the
other documents, though, so they were all consecutive -- I don't think
there's any way to get the RD field to specify a volume number to the INDEX
field.

Once the index is complete, you should be able to just save it as a web page
(use the "Web Page, Filtered" choice in the Save As dialog to reduce the
Word-specific HTML coding to a minimum).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.



.

Relevant Pages

  • Re: Word Index entry limitations?
    ... Please reply to the newsgroup unless you wish to avail yourself of my ... ' John, Mary, Susan ... Dim strConcat As String 'build return string ... entries in just the first 23 volumes. ...
    (microsoft.public.word.vba.general)
  • Re: Where is the "Normal" file in Word 2007?
    ... Oh Jay - what wonderful news! ... John (IDontBelieveIt) ... macros and templates for Microsoft Word ...
    (microsoft.public.word.newusers)
  • Re: Word Index entry limitations?
    ... ' John, Mary, Susan ... Dim rs As DAO.Recordset ... Dim strConcat As String 'build return string ... process for all 200,000 entries. ...
    (microsoft.public.word.vba.general)
  • Re: Word Index entry limitations?
    ... ' John, Mary, Susan ... Dim rs As DAO.Recordset ... Dim strConcat As String 'build return string ... process for all 200,000 entries. ...
    (microsoft.public.word.vba.general)
  • Re: Totally lost - please help
    ... John D'Errico wrote: ... My entries keep failing with the following message: ... I was referring to the MATLAB contest that is now running on ... Thanks for the suggestion, ...
    (comp.soft-sys.matlab)
Loading