Results 1 to 3 of 3

Thread: Hyperlink

  1. #1
    Join Date
    Jan 2011

    Unanswered: Hyperlink

    I have a field set to Hyperlink. This field shows the path to a directory where I keep PDF images.


    g:\pdf\12345.pdf (12345 being the order number)

    On a form, if i type the address "g:\pdf\12345.pdf" into the hyperlink field and then click on it, the PDF Opens.

    I am trying to automate the entering of the path into this field. I do this in my order entry form. When An AUTO number order number is generated, I have code showing:

    hypPath = "g:\pdf\" & OrderNumber & ".pdf"

    This adds the path into the hyperlink field ok.

    When I then click on this link in my form, nothing happens. If I retype the path into the field on the form, then click, it works fine.

    Anyone any ideas?

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Haven't tried using hyperlinks in Access, so this is a shot in the dark. Have you tried requerying/repainting the form after populating that field?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  3. #3
    Join Date
    Jan 2011
    I actually, close the order input form and open a different form to view the hyperlink address. So, yes, I have tried that. Thanks.

Posting Permissions

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