Change to hyperlink (1 Viewer)

[kitty77]

I have a table with a text field that I want to change to a hyperlink. I'm getting this error?
The table has about 36,000 records.

 

[June7]

Why do you want to use Hyperlink type? Just so the Hyperlink dialog is available? A non-hyperlink field can be used to build a hyperlink string. I avoid Hyperlink type field.

Try creating a new Hyperlink type field and run an UPDATE action to populate then delete the original field, rename the new field.

UPDATE tablename SET newfield = "#" & [oldfield] & "#"

 

[Pat Hartman]

The Hyperlink data type is not supported by SQL Server so I don't use it. Leave the hyperlink as a text field. If you want a description, add a second field. You can set the display properties of the Hyperlink or the display field to Hyperlink. Then in the double click event, Use the FollowHyperlink method to open the document/webpage/image. As long as the file type is known to Windows, Windows will know how to open the file.

 

[kitty77]

Thanks!

 

[HillTJ]

@kitty77 , i use some code from allenbrowne.com called 'GoHyperlink', the usage notes are easy to follow. I'd suggest you google this. Sorry, i'm writing this response from my phone & don't know how to copy/paste the link. Will do so for you when i open my PC.

 

[isladogs]

This is the link that @HillTJ was referring to...
Microsoft Access tips: Opening hyperlinks (allenbrowne.com)

 

[HillTJ]

@isladogs , Thanks for that.