By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Creating a hyperlink from the Switchboard

P: 2
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
Sep 4 '07 #1
Share this Question
Share on Google+
5 Replies


epots9
Expert 100+
P: 1,351
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
Sep 4 '07 #2

pbmods
Expert 5K+
P: 5,821
Moving to the Axes Forum....
Sep 4 '07 #3

ADezii
Expert 5K+
P: 8,669
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.
    Expand|Select|Wrap|Line Numbers
    1. Public Function fFollowHyperlink()
    2.   'Open the Yahoo Home Page in a New Window
    3.   Application.FollowHyperlink "http://www.yahoo.com", , True
    4. 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.
Sep 4 '07 #4

P: 2
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.
    Expand|Select|Wrap|Line Numbers
    1. Public Function fFollowHyperlink()
    2.   'Open the Yahoo Home Page in a New Window
    3.   Application.FollowHyperlink "http://www.yahoo.com", , True
    4. 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.
Sep 5 '07 #5

ADezii
Expert 5K+
P: 8,669
This worked great. Thank you so much!
You are quite welcome.
Sep 5 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.