follow hyper

S

smason

Hello!

I have a field in a form which is a hypeerlink called "CV" how can i make a
button to open file address thats in the field!

The address is a file not a web site!

thanks in advance
 
D

Dale Fye

If the field is actually a hyperlink datatype, you should just be able to
click on the field on a form in order to activate the hyperlink.

On the other hand, you could just store the hyperlink as text, in which case
you could use the Application.Followhyperlink method:

Application.Followhyperlink me.txt_FileName

HTH
Dale
 
S

smason

Hello

i still cant get this to work! where do i put the code in the button or in
the actual field in say 'on dbl click' !?!?!! the field name is cv
 
D

Dale Fye

You could put it in the fields doubleClick event. I generally create a
command button and put it in the Click event of that button.

You still have not indicated whether the field is actually a text or a
"hyperlink" datatype.

If it is not working, have you checked to make sure the file actually exists?

You might want to try something like:

IF LEN(DIR(me.cv)) = 0 then
msgbox "File does not exist in the indicated directory"
else
application.followhyperlink me.cv
end

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Top