Results 1 to 5 of 5
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Hyperlink Parameters

    I don't know if this is even possible, but here we go . . .

    I have a command button on a form with Application.FollowHyperlink containing " . . . \frmPropagate\" & Me.PropagationNo
    This works fine for opening the folder on my drive with the folder name equal to the "PropagationNo" on my form. I would like to be a bit more specific in the selection by adding the ID number of the record. Unfortunately this doesn't work:

    " . . . \frmPropagate\" & Me.PropagationNo & Me.ID

    Clearly, I don't know what I'm doing. Can this even be done with a hyperlink?
    Any help, as always, greatly appreciated.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Bryan,

    If PropgationNo is the folder then may we assume that ID number is the Filename?
    If so, then . . . \frmPropagate\" & Me.PropagationNo & "\" & Me.ID & ".ext"

    If it is not the filename but rather an individual folder with the ID number attached try:
    . . . \frmPropagate\" & Me.PropagationNo & format(Me.ID,"#")
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    bfxtrfcmgr (2012-10-17)

  4. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Thumbs up

    SWEET!

    Your first solution wasn't exactly what I was going for, but wow what an improvement
    Now I can actually open the document (as opposed to the mere folder). Thanks RG (you da best), very cool.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  5. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Bryan,

    I just noticed that I didn't put the format() command in the first example...it was supposed to be there!
    . . . \frmPropagate\" & Me.PropagationNo & "\" & format(Me.ID,'#') & ".ext"
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #5
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Haha, worked without it. But I changed it anyway.
    BTW (in case anyone's watching) that's "#" and not '#'

    Thanks again RG!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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