Please help - prefix text to a field

[bzeebee]

Hi
I created a hyperlink field in the table .
This is supposed to hold the link to a resume [.doc file] that is stored on the hard drive of the production server.


When a user enters the name of the resume I want to be able to prefix the name by "\\ABCserver\resume\"

For example :

Let say the users resume is entered on the form as ABCresume.doc

I want to be able to view the resume by clicking on this form field and I know to click on this and see the resume it would have to be stored as

\\ABCserver\resume\ABCresume.doc

in the table

Please help

 

[trucktime]

Hyperlink

First of all, I would use a text field instead of a hyperlink field to store the link and use the Application.FollowHyperlink method. Suppose your link field name is Link
Then put this code in the On Click event of the box:

Dim FLink As String
FLink = "\\ABCserver\resume\" & [LINK]
Application.FollowHyperlink FLink

Good Luck
Trucktime

 

[ghudson]

How about...

Application.FollowHyperlink "\\ABCserver\resume\" & [TextBoxLINK]

 

[bzeebee]

Modification

Thanks that works

Can this be modifed to throw a message box / pop-up to say "No resume " if there is no entry for this resume


thanks a lot
b

 

[ghudson]

If IsNull(TextBoxLINK) or TextBoxLINK = "" then
     Msgbox "No resume"
else
     Application.FollowHyperlink "\\ABCserver\resume\" & [TextBoxLINK]
end if