Results 1 to 5 of 5

Thread: Hyperlink??

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Hyperlink??

    Hi,

    I'm currently designing a form (Access97) and next to a dropdown box I want a to create a link that if clicked on takes me to a Word doc.

    The Word doc would give an explanation of the variables available in the dropdown box.

    Is this at all possible?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    you could try this, as long as the value in the combobox was the same as the file name

    Private Sub Label6_Click()

    Label6.HyperlinkAddress = "C:\" & Combo3.Value & ".Doc"

    End Sub

  3. #3
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    Technically it should be possible, the location of the word files may give you some grief if they are stored locally though.

    I would have a 'hidden' column in the combo box and have the hyperlinks in there.

    Then when the user selects an option the document would be called for.

    There may be a better way, but I couldn't think of one, off the top of my head.

    Ken.
    Last edited by Ken_Hart; 03-29-04 at 09:43.

  4. #4
    Join Date
    Mar 2004
    Posts
    36
    Brilliant, it works!!

    Thanks very much

  5. #5
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    Also, just thinking about it even more if they are just word documents you could just use the :


    The_File = "c:\your\document\here.doc"

    Set Word = CreateObject("Word.Application")

    Word.Documents.Open FileName:=The_File
    Word.Application.Visible = True


    That would work too !

    Ken

Posting Permissions

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