Hyperlink ActiveX Referebce file

[Coxylaad]

Hi,
I am trying to create a hyperlink using vba in access with the following code:

dim link as hyperlink

set link = new hyperlink ***** error here *****
link.Address = tempstr
link.TextToDisplay = FileNamestr

When I get to the marked line I get the following error:
Error 429:
"ActiveX object cannot create object"

Is there a reference file that I need to include in the database?

Thanks

Ian

 

[PHV]

The Access.Hyperlink object is always related to a control (image, label, button).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244