Hyperlink question...

N

Niko

Hi all, (I'm new to Access)

I've got a question which could be (most possibly) rather silly...
I want to make a field in a table to be a link to a common folder on a
server.
So I chose Hyperlink.What I actually want is the value that will be
entered to have allready a path predefined by me. So the user of the
db will just enter e.g 201004-1.pfd in the field but it will actually
be something like \\intranet\db\<value entered>


I'm looking to find out how to do that, but maybe I won't find it.I
think someone of you will now the answer and it'll be an easy one...
 
A

Arvin Meyer

You can hard code the path and use a command button or label to fire the
hyperlink. Something like:

Private Sub Form_Current()
Me.MyLabel.HyperlinkAddress = "\\intranet\db\" & Me.txtMyTextBox
End Sub

With this code, you won't even need a hyperlink datatype, as a plain text
field will work.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
N

Niko

Arvin thanks a lot for your time...

But as I told you I'm really really new to Access and I don't
understand which values to replace with my own in this :
Private Sub Form_Current()
Me.MyLabel.HyperlinkAddress = "\\intranet\db\" & Me.txtMyTextBox
End Sub
Click to expand...

So if you'd be so kind to point me to right direction or explain it a
little bit it could be usefull.
I'm trying to accomplish that by using the Input Mask and entering
"\\servername\foldername\"CCCCCCC".pdf";; but it doesn't do what I
want obviously you people understand.I'd like to be able to enter as
much as characters as I want and to take the .pdf extension
automatically.

Or another thing... browse and clicking a file to automatically enter
the path and filename!!
 
Top