Hyperlink Help

  • Thread starter Thread starter hotplate
  • Start date Start date
H

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
 
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
 
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 said:
Hi,
Click to expand...
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
Click to expand...
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?
Click to expand...
And for a bonus.....
Is it possible to create the folder when the check mark is checked?
Click to expand...
James
Click to expand...
Click to expand...


I appreciate the help. Everything works now.
 
Back
Top