Hyperlink field and icon

  • Thread starter Thread starter FatMax
  • Start date Start date
F

FatMax

I'm using an Access 97 database to manage documents. Very basic thing
with table containing document name, document type (.doc/.ppt/.pdf)
and a hyperlink to document. Also in the table is a field for a
document icon (OLE object).

This all goes very nicely onto a form (except following the hyperlink
opens Access' web toolbar - I think I've found the answer to this
though googling this group's archives). What I'd really like to do is
be able to click on the icon or the hyperlink field to open the
relevant document. What should I be putting in the OnClick event of
the icon?? RunApp probably isn't an option as the db (and documents)
will eventually end up on a variety of systems.

Form is called frmSTByYear, hyperlink field is called STLink and icon
field is called STIcon if this helps.

TIA
FatMax
 
Gosh I only faintly remember my days using Access 97, but at least in Access
2000 clickbuttons have a property called "hyperlink address". If you
physically click on this property, you'll get a hyperlink wizard that will
help find the address of your form. Once you select it, the wizard will
automatically associate that clickbutton with said address. I'm sure that
you can also achieve the same with code...

Regards,
Al
 
Back
Top