Hyperlink Issue Access Front-end and Sequel Back-end

[Guest]

Please help.... I am migrating database tables to a sequel server with an
Access front-end. In sequel, I cannot set the field properties as a
hyperlink, but I need it to perform that way in Access. Is there a macro I
can create to have it turn the path in a text field into a hyperlink “on
click�

 

[Douglas J. Steele]

You can use Application.FollowHyperlink "LinkToFollow"

(where you'd put your value from the table where "LinkToFollow" is)

Incidentally, it's SQL Server, not sequel server.

 

[Guest]

Thanks so much on both topics. SQL is very new to me. With that, I need to
ask one more question...

Do I set this value in the SQL table somewhere (if yes, where) or do I set
this value in the Access form that is using the field? I'm not sure where to
place the what you gave me.

Thanks again!
--
~ Chris

You can use Application.FollowHyperlink "LinkToFollow"

(where you'd put your value from the table where "LinkToFollow" is)

Incidentally, it's SQL Server, not sequel server.

 

[Douglas J. Steele]

What I gave you (Application.FollowHyperlink) is VBA code that you'll put in
some event on your form in Access.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks so much on both topics. SQL is very new to me. With that, I need to
ask one more question...

Do I set this value in the SQL table somewhere (if yes, where) or do I set
this value in the Access form that is using the field? I'm not sure where
to
place the what you gave me.

Thanks again!