Hyperlink

[Andria]

Hello,

I have a field in a datasheet form. I want the user to be
able to put a hyperlink attachments. Attachments are all
in one folder that is common to alla users. So when
another user login to the system to be able to click on
that hyperlink and open the specific attachment

Than you in advance!!
Andria

 

[Arvin Meyer]

You can define the field in the table as a hyperlink datatype and carry the
property attributes to the forms. You can also use a plain text field and
use the double-click event of the form's text box to follow the hyperlink
with code like:

Private Sub txtHyperLink_DblClick(Cancel As Integer)
Application.FollowHyperlink HyperlinkPart(Me.txtHyperLink, acAddress)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access