Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Imported Hyperlinks (2003)

    Hiya

    We're getting ready to move to our new Access DB, and I've done a dummy run importing data from our old mysql database. My problem is that Access is importing the 'Website' field, but it's only importing the field as 'Text to Dislpay' and not the actual Address. Therefore, even though the URL is displayed, clicking it does nothing as the Field is technically blank.

    Does anyone know how to get Access to import this correctly?

    Thanks in advance for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Imported Hyperlinks (2003)

    Is the field defined as a Hyperlink field in Access?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Imported Hyperlinks (2003)

    It is indeed.

    Clicking the Hyperlink Icon on the Access Toolbar brings up the Hyperlink Field Dialog Box; as far as I know, you can only do this if the Field is a Hyperlink. If the Field isn't a Hyperlink, the Hyperlink Icon is Disabled on the Toolbar.

    Thanks for your quick reply. [img]/forums/images/smilies/smile.gif[/img]

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Imported Hyperlinks (2003)

    Hyperlinks are essentially a modified memo field that use the # character as a delimiter between the address field and the description in Access. I think you may want to import the hyperlinks to a text field first, and then change the field type to hyperlink, and see if that does the trick. You might also want to look at <!mskb=826763>Microsoft Knowledge Base Article 826763<!/mskb> for some of the details about hyperlinks. We often prefer storing the URL in a text field, and then displaying it as a hyperlink on a form.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •