Still struggling with hyperlink command button

[NotVeryTechie]

Here's what I am trying to do - I have a hyperlink field. Next to the field I want to put a command button. When the user clicks on this it will open explorer (or similar) and the user can browse to the correct folder, then select it. And this will be stored in the hyperlink field.

How on earth do I do this? Or am I being way overambitious??

 

[ajetrumpet]

Good question.

Could you go about another way? Like maybe, giving the user a list of available targets? There is always the application.followhyperlink method to use with the button...

 

[NotVeryTechie]

What do you mean by application.followhyperlink method?

I would basically like the user to select a folder, or be able to create a folder. The folders will all be in a specific place and they would need to create/select a sub folder in that list.

 

[ajetrumpet]

the application.followhyperlink method does exactly that...it follows a hyperlink. So, if you want to open to a specific folder, you write:

application.followhyperlink "ADDRESS"

 

[NotVeryTechie]

Hi ajetrumpet - sorry to sound dense, but does this link to a specific address? What I am looking to do is create a Browse button so that the user can select a folder which will be stored in the hyperlink field. They can then click on this when they next need to look up the documents.

 

[TLEnder]

Hi

This might be a bit out of date, but maybe it can help someone else.

you can add the following to the On Click event of a button -

Me.[your Hyperlink field].SetFocus
DoCmd.RunCommand acCmdInsertHyperlink

When you click the button it will open the same dialog box as if you had right clicked and selected Hyperlink and then Edit Hyperlink.

Hope that helps.

TLEnder

 

[rfear]

Bit after the fact, but helped me today

 

[tragik]

Hi

This might be a bit out of date, but maybe it can help someone else.

you can add the following to the On Click event of a button -

Me.[your Hyperlink field].SetFocus
DoCmd.RunCommand acCmdInsertHyperlink

When you click the button it will open the same dialog box as if you had right clicked and selected Hyperlink and then Edit Hyperlink.

Hope that helps.

TLEnder

Thanks, this helped me!!!

 

[moonoo]

Hi

This might be a bit out of date, but maybe it can help someone else.

you can add the following to the On Click event of a button -

Me.[your Hyperlink field].SetFocus
DoCmd.RunCommand acCmdInsertHyperlink

When you click the button it will open the same dialog box as if you had right clicked and selected Hyperlink and then Edit Hyperlink.

Hope that helps.

TLEnder

it's very outdated and very useful help. Thank you.

 

[Abstergo]

No matter how old it is, this thread saved me a ton of time today. Thanks!!