[Accessusergroup] [AccessUserGroup] Creating an index in a report

[HELENIHI Noah]

Hi Deborah,

I don't know if anyone has already responded to this. If you didn't need
to keep your list it would be pretty easy to create an index or table of
contents like this in Word. Word pretty much creates these
automatically. However, if it must be in Access you might consider using
a phonebook type o interface where users look-up the letter of the
subject they're interested in, then they choose from a list of subjects
beginning with that letter. The MS Office Site had s good example of one
of these in their "Northwind" sample database. (I have a modified
version also). Or, you  could just create a form where you had all of
your index topics listed. Then, make their "OnDoubleClick" event open
another form with the appropriate video titles listed. (Your question
was how to create an clickable index in a report. As far as I know, that
can't be done. Please, let me know if any of this helps. I would be
happy to provide specific advice should you decide to try and go with
any of the options listed above. I would also be happy to send you
sample forms or macros, etc. Good Luck!

Noah Helenihi
Procurement Programs Coordinator
ODOT Procurement Office
(503) 986-5757 Phone
(503) 986-4469 FAX
noah.a.helenihi at odot.state.or.us 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listsmart.osl.state.or.us/pipermail/accessusergroup/attachments/20060810/4b530a20/attachment.htm