Hyperlinks

[Guest]

Hello,


I have created a button on a form to create a folder relating to the specfic
record which works fine. What I want to do is use some code to store the
address of the folder in the hyperlink field. However I am not having much
success. Heres the code

Dim MyFolder, MyPath, MyHyper

MyFolder = Me![txtRef] & "_" & Me![txtCustomerName]
MyPath = "\\Server\\LossFiles"
MkDir MyPath & "\" & MyFolder
"It works to here creating the folder"
MyHyper = MyPath & "\" & MyFolder
Me.hypField = HyperlinkPart(MyFolder, acDisplayText)
Me.hypField = HyperlinkPart(MyHyper, acAddress)

Thanks in advance


Matt

 

[Alex Dybenko]

Try:

Me.hypField = HyperlinkPart(MyFolder, acDisplayText) & "#" &
HyperlinkPart(MyHyper, acAddress)

 

[Guest]

Thanks for your help Alex

However still not solved the problem the display text appears in the
hyperlink field however the address part is missing. Any more ideas????

Thanks in advance

Matt

Try:

Me.hypField = HyperlinkPart(MyFolder, acDisplayText) & "#" &
HyperlinkPart(MyHyper, acAddress)

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hello,


I have created a button on a form to create a folder relating to the
specfic
record which works fine. What I want to do is use some code to store the
address of the folder in the hyperlink field. However I am not having much
success. Heres the code

Dim MyFolder, MyPath, MyHyper

MyFolder = Me![txtRef] & "_" & Me![txtCustomerName]
MyPath = "\\Server\\LossFiles"
MkDir MyPath & "\" & MyFolder
"It works to here creating the folder"
MyHyper = MyPath & "\" & MyFolder
Me.hypField = HyperlinkPart(MyFolder, acDisplayText)
Me.hypField = HyperlinkPart(MyHyper, acAddress)

Thanks in advance


Matt

 

[Alex Dybenko]

Then try:
Me.hypField = HyperlinkPart(MyFolder, acDisplayText) & " " &
HyperlinkPart(MyHyper, acAddress) & "#" & HyperlinkPart(MyHyper, acAddress)

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Thanks for your help Alex

However still not solved the problem the display text appears in the
hyperlink field however the address part is missing. Any more ideas????

Thanks in advance

Matt

Try:

Me.hypField = HyperlinkPart(MyFolder, acDisplayText) & "#" &
HyperlinkPart(MyHyper, acAddress)

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hello,


I have created a button on a form to create a folder relating to the
specfic
record which works fine. What I want to do is use some code to store
the
address of the folder in the hyperlink field. However I am not having
much
success. Heres the code

Dim MyFolder, MyPath, MyHyper

MyFolder = Me![txtRef] & "_" & Me![txtCustomerName]
MyPath = "\\Server\\LossFiles"
MkDir MyPath & "\" & MyFolder
"It works to here creating the folder"
MyHyper = MyPath & "\" & MyFolder
Me.hypField = HyperlinkPart(MyFolder, acDisplayText)
Me.hypField = HyperlinkPart(MyHyper, acAddress)

Thanks in advance


Matt