Still struggling with hyperlink command button (1 Viewer)

NotVeryTechie · Jun 20, 2008

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 · Jun 21, 2008

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 · Jun 23, 2008

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 · Jun 23, 2008

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

Code:

application.followhyperlink "ADDRESS"

NotVeryTechie · Jun 24, 2008

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 · Aug 19, 2008

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 -

Code:

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 · Sep 25, 2008

Bit after the fact, but helped me today

tragik · Jul 3, 2009

TLEnder said:
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 -

Code:

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 · Aug 9, 2012

TLEnder said:
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 -

Code:

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 · Jun 3, 2013

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

Still struggling with hyperlink command button (1 Viewer)

NotVeryTechie

Registered User.

ajetrumpet

Banned

NotVeryTechie

Registered User.

ajetrumpet

Banned

NotVeryTechie

Registered User.

TLEnder

New member

rfear

Registered User.

tragik

Registered User.

moonoo

New member

Abstergo

New member

Similar threads

Users who are viewing this thread