Hi everyone
I'm in MS Access 2007. I use RTF fields to create non-fiction books/stories.
I would like ideas, and preferably also a whole VBA code to be able to create a routine (for each book/story I write) that creates a purpose built index, just like many books have as of course you would know.
The result of the process I am seeking would be a form which displays
However, it seems to me that the basic idea above is very simple in concept. So it surprises me that there isn't (as far as I could see) any free or cheap freeware "out there" that would do what I'm looking for. I have searched various forums but perhaps I didn't think of the appropriate search phrase.
I'm really hopeful that a simple code that works can be invented by your local gurus and/or that you can suggest links to other wise sites that might be able to help. The alternative to having this routine would be unthinkable - a manual search by observation, note taking, bits of paper, etc etc. One of my books has about 15,000 words. So, NO ...!!! Thank you, in advance, good people.
Ed K 8 January 2022
I'm in MS Access 2007. I use RTF fields to create non-fiction books/stories.
I would like ideas, and preferably also a whole VBA code to be able to create a routine (for each book/story I write) that creates a purpose built index, just like many books have as of course you would know.
The result of the process I am seeking would be a form which displays
- a word list for the particular book, in alphabetical order
- against each word would be
- the word count for that word
- a box for me to tick against each word so that (if I want) it is excluded from the index
- the document (book) page number(s) that the particular word appears on
- a command button that produces the index that would then come up as a report
- a command button which I can use to then print off the index in however many columns per page I want - I know how to do this particular bit (the print command button) OK, I think
- A nice optional extra would be to have a separate table of excluded common words (such as a, the, would, I, you, me etc etc etc) so the routine knows not to include them in its search/list/count - now there's an extra challenge for somebody here .... ???!!!!! I guess another tick box "exclude from search" would do the trick?
- I'm guessing that the search result may have different font sizes etc and different font types, so a routine that has a font choice drop down box to apply to the result of the routine (ie the list as made by points 1 & 2 above) would also be nice optional extra, but I think I could manage that also.
However, it seems to me that the basic idea above is very simple in concept. So it surprises me that there isn't (as far as I could see) any free or cheap freeware "out there" that would do what I'm looking for. I have searched various forums but perhaps I didn't think of the appropriate search phrase.
I'm really hopeful that a simple code that works can be invented by your local gurus and/or that you can suggest links to other wise sites that might be able to help. The alternative to having this routine would be unthinkable - a manual search by observation, note taking, bits of paper, etc etc. One of my books has about 15,000 words. So, NO ...!!! Thank you, in advance, good people.
Ed K 8 January 2022