Store hyperlink in table but display on form, report, webpage etc...

[Spyder757]

I'd like to be able to store the hyperlink of a graphic file in my table but be able to display this image (rather than the link) any time I query it for a web page or form.

Is this possible, or am i taking the wrong route on this?

 

[Terpsfan]

This is definitely doable in Access. I would create a hyperlink field as well as a field that stores the image (OLE field in Access). The OLE field would point to the hyperlink field. In the hyperlink field you would specify the file location. On your form you would basically just drop the OLE field name from the field list or on your report.

 

[Spyder757]

Good stuff i'll try it out.

 

[Terpsfan]

Send me your email address and I will send you a code example in a demo database.

 

[Spyder757]

Spyder757@yahoo.com

Thanks.