Browse files for hyperlinks

[mikemaki]

I posed this in a reply to a thread a ways down, but I am asking again to help it to be viewed by more forum visitors. I've built a form that lists hyperlinks in a text box The source field in the table is defined as hyperlink. All data in the text box is displayed as hyperlink. If a file location is typed in, what appears as a hyperlink acts like a hyperlink. It takes the user to that location when clicked. I've built a browse button which opens the "OpenSave" dialog box to allow users to save a hyperlink that way. But the address doesn't seem to get stored with it. It looks like a hyperlink, but when clicked, it doesn't act like one. I've tried assigning the .address property in the code, but it tells me the property cannot be updated. My boss claims you can't store a hyperlink from a dialog box. I tend to be more optimistic. Can anyone out there help me out?

 

[Hayley Baxter]

I use something similar to this but rather than having a button on the form to open the dialoug box, I have a custom menu with the hyperlink property on here. Upon selecting the hyperlink property it opens the insert hyperlink dialoug box so you can then browse for your file or website location to link to, the hyperlink is then added and works as it should.

I realise my situation is a little different but thought it might be worth suggesting.

 

[IgorB]

Yes you can do it.
When use dialog box and get File Path from it you store this path to a field in a table.
But what is important YOU HAVE TO FORCE pound signs in VBA code like:
#YourFilePath#
It works for me just fine.
Take care.
Igor.

 

[Mile-O]

Re: Re: Browse files for hyperlinks

pound signs = #

Out of interest, if they are "pound signs", what do you call these: £ ?

 

[mikemaki]

Thanks Igor! And to us Yanks, they are pound signs.

 

[Mile-O]

So, what do you call these: £ ?

 

[mikemaki]

I've never had to refer to one of those squiggly things the British use. But if I did have to, I would probably call it one of those squiggly things the British use.

 

[Mile-O]

It's a pound sign, man; # is a hash.

 

[mikemaki]

OK. You win. (I thought hash was what I had for dinner last night) All kidding aside, it's really interesting taking part in a forum with an international scope and being exposed to cultural differences.