Creating a hyperlink from the Switchboard

[sljohnson]

Hi there. This may be a really simple question for some of you, but I am stuck. I am trying to create a hyperlink to a web page from the switchboard in Access. I have been using the RunApp command in macros to link to a folder and an excel file, but I am not having any luck following the same model to get to a web page.

Can someone please advise? Thank you,
Stacey

[epots9]

Hi sljohnson welcome to TSDN,

in design view, for the row you want to be a hyperlink change the data type to hyperlink. Then what data are in those fields it will go to "http://field-value".

In perview you can right click the hyperlink and a hyperlink tab will be enabled then you can edit where the link goes (have to done for every entry, changing one will not change the others).

good luck

[pbmods]

Moving to the Axes Forum....

[ADezii]

Hi there. This may be a really simple question for some of you, but I am stuck. I am trying to create a hyperlink to a web page from the switchboard in Access. I have been using the RunApp command in macros to link to a folder and an excel file, but I am not having any luck following the same model to get to a web page.

Can someone please advise? Thank you,
Stacey

Here are the steps necessary in order for you to Navigate to a Hyperlink Address from an Access Switchboard Item:

1. Create a Public Function named fFollowHyperlink.
   

   Public Function fFollowHyperlink()
     'Open the Yahoo Home Page in a New Window
     Application.FollowHyperlink "http://www.yahoo.com", , True
   End Function

2. Select the Switchboard Item that the User will use to Navigate to the Hyperlink Address.
3. Enter the following Arguments for the Switchboard Item:
   1. Text: Open Yahoo Home Page
   2. Command: Run Code
   3. Function Name: fFollowHyperlink
4. You can, of course, change the Function Name, and the Text for the Switchboard Item to something more appropriate.

[sljohnson]

This worked great. Thank you so much!

Here are the steps necessary in order for you to Navigate to a Hyperlink Address from an Access Switchboard Item:

1. Create a Public Function named fFollowHyperlink.
   

   Public Function fFollowHyperlink()
     'Open the Yahoo Home Page in a New Window
     Application.FollowHyperlink "http://www.yahoo.com", , True
   End Function

2. Select the Switchboard Item that the User will use to Navigate to the Hyperlink Address.
3. Enter the following Arguments for the Switchboard Item:
   1. Text: Open Yahoo Home Page
   2. Command: Run Code
   3. Function Name: fFollowHyperlink
4. You can, of course, change the Function Name, and the Text for the Switchboard Item to something more appropriate.

[ADezii]

This worked great. Thank you so much!

You are quite welcome.