Hyperlinks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try:

Me.hypField = HyperlinkPart(MyFolder, acDisplayText) & "#" &
HyperlinkPart(MyHyper, acAddress)
 
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

Alex Dybenko said:
Try:

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

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


Matt said:
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
Click to expand...
Click to expand...
 
Then try:
Me.hypField = HyperlinkPart(MyFolder, acDisplayText) & " " &
HyperlinkPart(MyHyper, acAddress) & "#" & HyperlinkPart(MyHyper, acAddress)

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


Matt said:
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

Alex Dybenko said:
Try:

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

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


Matt said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top