Browse and display in hyperlink textbox

[Quicksand10]

Hi all,

I'm trying to use ghudson's browse button in a form on MS Access. It works well, but I'm running into a tiny bug after implementing it into my database.

thread 97787 (I can't post hyperlinks)

I am able to browse, I am able to select a file, and am also able to have it display into the hyperlink textbox.
However, when I try to click on the hyperlink in the textbox, it does not take me to the file.
To fix the bug, and to get the hyperlink working again, I have to modify the hyperlink within the textbox, then bring it back as it was. (generally, I hit backspace, and replace the letter I removed.)

Any ideas?

Thanks

 

[James Dudden]

It may be because you are doing it in VBA and therefore the AfterUpdate of the textbox doesn't run to confirm a new entry has been made. You could try saving the data once it is in the textbox using DoCmd.RunCommand acCmdSaveRecord

 

[Quicksand10]

Hi James,

Thanks for the quick reply.

I tried your suggestion, it didn't work, unfortunately. I tried it at the end of the ParseFileName Function, and on TextBox_Exit (just to test).
I'm going to try to troubleshoot this today, and if I come up with an answer, I'll post here.

-Q

 

[Quicksand10]

Hey all,

I still can't figure it out. Any ideas?

I'm running Access XP on Windows XP, and this problem happens with both the Browse Directory and Browse Files functionalities.

Thanks, I appreciate your help.

 

[Quicksand10]

I found the answer to my question on stack-overflow:
Search for "Access - Hyperlinks aren't linking"

Turns out you need to concatenate #'s before and after the hyperlink address for it to work properly as a hyperlink.

for example:

Dim NetAddress As String
Me.TextBox1.Value = "#" & NetAddress & "#"

-Q

 

[James Dudden]

Thanks for posting back as I was going to have another look at this shortly.
Oh, and well done for figuring it out. Always the best way to learn

 

[sumox]

ya, best thing to learn is Discover !

how much u Dig into Internet resources, how much u find !