how do I build a hyperlink from fields

A

Allen Browne

In the Click event procedure of your command button, you can read the name
from the FirstName field, and build the string to use with FollowHyperlink:

Dim strLink as String
If Not IsNull(Me.[FirstName]) Then
strLink = "http://www.myfamily.biz/" & Me.[FirstName] & ".html"
FollowHyperlink strLink
End If
 
A

Aaron

Thank you so much. I finally found a post that solved the same issue problem.
Worked like a charm. Allen, you've saved me many times before.



Allen Browne said:
In the Click event procedure of your command button, you can read the name
from the FirstName field, and build the string to use with FollowHyperlink:

Dim strLink as String
If Not IsNull(Me.[FirstName]) Then
strLink = "http://www.myfamily.biz/" & Me.[FirstName] & ".html"
FollowHyperlink strLink
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

DerekB said:
Please can someone tell me how to configure a command button so that it
will
link to http://www.myfamily.biz/[name].html where 'name' changes with each
record and is a field stored in access 2003 database. i.e. hyperlink to
http://www.myfamily.biz/john.html
Click to expand...
Click to expand...
 
Top