Hyperlinks

M

Matt

I have designed some code to make a folder based on 2 field values and then
place the address of the folder location into a hyperlink field. I have
placed the code behind a button in a form. The code creates to folder no
problem but I can not get the hyperlink field to store the location of the
folder. Can anyone tell me what I am doing wrong.

MyFolder = Me![txtJobNo] & "_" & Me.txtCustomerName]
MyPath = "\\server\LossFiles"
MkDir MyPath & "\" & MyFolder
---work to here
MyHyper = MyPath & "\" & MyFolder
Me.hypPath = HyperlinkPart(MyFolder, acDisplayText)
Me.hypPath = HyperlinkPart(MyHyper, acAddress)

I can get the hyperlink field to display text and not to hold the folder
location. This is driving me mad

Thanks Inadvance

Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks 3
Moving Folders 1
Getting hyperlink field to work 0
hyperlink fields 1
Checking if a word doc exists 4
Insert OLE object 1
Hyperlinks 0
VBA - exporting serial letters to single documents 0

Top