Hyperlink Help

[hotplate]

Hi,

Here is what I am trying to do:
I have a check box with an after update if the check box is checked
then the value of a hyperlink is something like:
If Me![Checkbox] = -1 Then
Me![Hyperlink] = "U:\Network Folder\Issues\" & Me![ID]
Else
Me![Hyperlink] = ""
End If

The problem I have is that it is entering the hyperlink as text to be
displayed, and there is no value for the address. How would I create
the hyperlink address not just the text to be displayed?

And for a bonus.....
Is it possible to create the folder when the check mark is checked?

James

 

[Guest]

For the hyperlink part of your question, the following works fine for me on
my db.

DocPath= "C:\Temp\DocName1.xls"
FileName = Dir(Docpath)
Me.FieldName= FileName & "#" & Docpath & "#"

Is your field properly setup as a hyperlink? In the table as well?

To make a directory simply use Mkdir

Example:
MkDir then the path
MkDir "C:\Storage"

Daniel

 

[hotplate]

For the hyperlink part of your question, the following works fine for me on
my db.

DocPath= "C:\Temp\DocName1.xls"
FileName = Dir(Docpath)
Me.FieldName= FileName & "#" & Docpath & "#"

Is your field properly setup as a hyperlink? In the table as well?

To make a directory simply use Mkdir

Example:
MkDir then the path
MkDir "C:\Storage"

Daniel

Hi,

Here is what I am trying to do:
I have a check box with an after update if the check box is checked
then the value of a hyperlink is something like:
If Me![Checkbox] = -1 Then
Me![Hyperlink] = "U:\Network Folder\Issues\" & Me![ID]
Else
Me![Hyperlink] = ""
End If

The problem I have is that it is entering the hyperlink as text to be
displayed, and there is no value for the address. How would I create
the hyperlink address not just the text to be displayed?

And for a bonus.....
Is it possible to create the folder when the check mark is checked?

James

I appreciate the help. Everything works now.