Creating Hyperlinks in SQL Tables

Question

Creating Hyperlinks in SQL Tables

Ryan Criseno

SSC Veteran

Points: 272
More actions
June 14, 2006 at 4:34 pm

#67450

Hey everyone,
I've been working with Access alot lately but am slowly moving to SQL Server. We've got tables with Document names in em', we've also got Hyperlinks which navigate directly to the document.
How can we keep these Hyperlinks in SQL Server Tables???? Help . . .

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Charles Wannall Ten Centuries Points: 1003 More actions · Answer 1

Hyperlinks can be stored as plain text in a varchar or nvarchar field in SQL Server. Your interface (access, asp, vb, whatever) will provide a control that you put on your form/page. You'll bind/set the value of the hyperlink into that control and click it.

Would that do?

Ryan Criseno SSC Veteran Points: 272 More actions · Answer 2

Oh good lord,

I could use the onClick event! Why didn't I think of that! Thanks for the suggestion! helped trememdosly(sp?)

Charles Wannall Ten Centuries Points: 1003 More actions · Answer 3

You can also stuff the path into the hyperlink address property of a hyperlink type label. You click insert on the menu bar, and insert a hyperlink.

I think you can start with a normal label and convert it but I don't remember how.

Anyway, once you insert any hyperlink on a form, you can clear the address and refill it from code. that way you get the nice underlining, the automatic display of the pointer finger when you hover over it, and color coding to reflect whether you've visited it or not.

Don't remember if that color coding works across sessions when you're stuffing different hyperlinks in the same control. If you experiment with that and find out, let us know.

Charles Wannall Ten Centuries Points: 1003 More actions · Answer 4

Oh yea - command buttons have the hyperlink address as well.

David Tooker Right there with Babe Points: 746 More actions · Answer 5

If you change your Access databases into Access projects with SQL backends then all you do is set your SQL hyperlink field to a varchar in SQL. In the form, you set the field to text box. In the properties of the text box, at the bottom of the properties window you set the IsHyperlink to yes. Then when you are on the form and want to enter a hyperlink, just right click and add your address and display text.

Dave