automating hyperlinks

Let's suppose I have a table in access 2k

id document
1 aaa.doc
2 bbb.doc
3 ccc.xls
4 ddd.txt
.. .
1500 xxx.doc

I need a clever code that will help me to assign a document name from
my table to the folder and its name where the document is stored
(C:\data\documents\).
Every document has an unique name therefore I would like to connect
the field (via hyperlink) in the table with its specific document. I
don't want to do it manually since there are about 1500 files.
My knowledge of VB is rather poor, therefore a suggestions should be
simple
Thanks

re: automating hyperlinks

Is every file in the same folder?

pozdrawiam
Tomek

re: automating hyperlinks

yes, the files are in the same folder



"Grochu" <tomasz.grochowski@gmail.com> wrote in message news:<1109675896.639504.266580@o13g2000cwo.googleg roups.com>...[color=blue]
> Is every file in the same folder?
>
> pozdrawiam
> Tomek[/color]

re: automating hyperlinks

Up

zombek_1@yahoo.com (Tomasz) wrote in message news:<4695d75.0503011227.2d609a6b@posting.google.c om>...[color=blue]
> yes, the files are in the same folder
>
>
>
> "Grochu" <tomasz.grochowski@gmail.com> wrote in message news:<1109675896.639504.266580@o13g2000cwo.googleg roups.com>...[color=green]
> > Is every file in the same folder?
> >
> > pozdrawiam
> > Tomek[/color][/color]