generating hyperlinks from data fields

  • Thread starter Thread starter LLew
  • Start date Start date
L

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
 
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.
 
I would never have guessed without newsgroup help where to start looking.
Thanks again.

Llew
 
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.!
 
Back
Top