Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-07-2009
Member
 
Join Date: Jul 2009
Posts: 118
Using hyperlinks in ms access 2007

WE frequently use Microsoft Access 2007 at office. I have created some hyperlinks in my Access 2007 that should take me to a web page related to the specific record or the link provided under the hyperlink. But the problem is while clicking on the hyperlink, nothing happens. The hyperlink won't work. Please help.
Reply With Quote
  #2  
Old 13-07-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Using hyperlinks in ms access 2007

The value returned depends on the setting of the part argument. The part argument is optional. If it's not used, the function returns the value Microsoft Access displays for the hyperlink. The returned values can be one of the four parts of the Hyperlink field, the full address, address#subaddress, or the value Microsoft Access displays for the hyperlink.The place using Impression as Hyperlink caused the text in TextBox or ComboBox for colored blue and underlined. Moreover, when hanging on the control, the cursor is a pointer in a Hand of the Hyperlink.
Reply With Quote
  #3  
Old 13-07-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: Using hyperlinks in ms access 2007

When you type a link into the datasheet's Hyperlink, it consist the text, the destination you go to when you click the cell and text you see when you hover over the link with your mouse. So while typing the link all these are set to the same value what you just typed in. So when you type http://www.techarena.in, the text you see, the URL link, and the tooltip are all set to hold the same content,which is the URL http://www.techarena.in. When a value is provided in the displaytext part of a Hyperlink field, the value displayed by Microsoft Access will be the same as the displaytext setting. When there's no value in the displaytext part of a Hyperlink field, the value displayed will be the address or subaddress part of the Hyperlink field, depending on which value is first present in the field.
Reply With Quote
  #4  
Old 13-07-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: Using hyperlinks in ms access 2007

You can add or edit the displaytext part of a hyperlink field by right-clicking a hyperlink in a table, form, or report, pointing to Hyperlink on the shortcut menu, and then typing the display text in the Text to display box.There?s an additional option for Display As Hyperlink ?Screen Only?. This is a great option to use when building the kinds of interactive reports which are now possible with Access 2007.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Using hyperlinks in ms access 2007"
Thread Thread Starter Forum Replies Last Post
Hyperlinks not opening in outlook 2007 trickson Windows Software 6 05-02-2012 06:56 AM
Access 2010 file in Access 2007 gives Unrecognized Database Format Roakman MS Office Support 3 11-12-2010 11:45 PM
Hyperlinks Not Linking Correctly in ms powerpoint 2007 Agathe Windows Software 4 18-09-2010 10:17 PM
Read Access 2003 files with Access 2007 Kendal-J Windows Software 2 26-05-2010 05:57 PM
Retrieve data from Access 2007 to Excel 2007 Markesh Windows Software 3 23-09-2009 08:20 AM


All times are GMT +5.5. The time now is 06:03 PM.