Hyperlink Parameters

Topic

New Reply

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.

Reply | Quote

Replies

Bryan,

If PropgationNo is the folder then may we assume that ID number is the Filename?
If so, then [noparse]. . . frmPropagate” & Me.PropagationNo & “” & Me.ID & “.ext”[/noparse]

If it is not the filename but rather an individual folder with the ID number attached try:
[noparse]. . . frmPropagate” & Me.PropagationNo & format(Me.ID,”#”) [/noparse]
:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

SWEET!

Your first solution wasn’t exactly what I was going for, but wow what an improvement :bananas:
Now I can actually open the document (as opposed to the mere folder). Thanks RG (you da best), very cool.

Reply | Quote

Bryan,

I just noticed that I didn’t put the format() command in the first example…it was supposed to be there!
[noparse]. . . frmPropagate” & Me.PropagationNo & “” & format(Me.ID,’#’) & “.ext”[/noparse]
:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Haha, worked without it. But I changed it anyway.
BTW (in case anyone’s watching) that’s “#” and not ‘#’

Thanks again RG!

Reply | Quote