generating hyperlinks from data fields

[LLew]

I have a tables (Access97) where the file names scans of invoices, delivery
notes and purchase orders are logged. I would like to have a hyperlink to
the specified files available from the database program. How do I actually
go about generating the link in a data field from say a fixed folder
location address e.g. c:\\data\invoices\January and the file name e.g.
Inv-1232456.jpg so that I end up with a clickable
c:\\data\invoices\January\Inv-1232456.jpg available to the database user? I
hope I'm making myself clear. The month part of the address may also be a
field value. Is concatenation the way to go?

Any help would be really useful.

Regards

Llew

 

[Van T. Dinh]

If you have Forms for your users to enter / view data, you can use the
FollowHyperlink method to open the "link" *dynamically* constructed in VBA
code.

See Access VB Help on the FollowHyperlink Method.

 

[LLew]

I would never have guessed without newsgroup help where to start looking.
Thanks again.

Llew

 

[steven]

I would like to do the same thing, in a way .... wherer
is the sample code??

 

[Van T. Dinh]

Did you check Access VB Help as advised in my previous reply for sample
code?

Access Help / Access VB Help should be your *first* source of info.!