Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126

    Unanswered: Hyperlink Dialog on a Form

    Hello,
    I've users linking each record on a form in Access 2000 to a .doc form on a network. I do have that field defined as Hyperlink however it's just a text field. I wish a dialog window would pop up that would enable me to link any file or URL to it (like in Excel). Any thoughts? Thank you

  2. #2
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    this is what i use

    xL_name = file.xls

    Code:
    Me.lbl_report_link.Visible = True
        Me.lbl_report_link.Caption = "To view your Excel file click here."
        Me.lbl_report_link.ForeColor = vbBlue
        Me.lbl_report_link.HyperlinkAddress = "\\Aus-reporting\Auditing\recovlog\Reports\Department_Error\" & "" & xL_name

Posting Permissions

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