Hyperlink question

[Vylent Fyre]

You rock, Douglas!!! Totally ROCK!

This is what I did that worked (thanks to YOU!)

If Len(Dir(HyperlinkPart(Me.Scanned_JE_Link), vbDirectory)) = 0 Then

You had (HyperlinkAddress but Access (I'm sure my version of it) didn't like
that so I changed it to HyperlinkPart and it worked PERFECTLY! 100% I
cannot thank you enough; this has helped me SO much! Thank you!!!

Do you have any websites that has information about Access? I would
definitely go there before pestering other people first =)

Vylent Fyre

 

[Douglas J. Steele]

Jeff Conrad has an excellent set of links to good Access sites at
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

 

[Vylent Fyre]

One more thing - Is there a way I could add a sort option? Basically, I'd
like the report to show the "File/Directory not found" on top of the report,
then "Dir confirmed" then "File confirmed" - could I make the report do this
with this coding? I know how to write it if it was a field but this isn't a
field/control....

 

[Douglas J. Steele]

I believe the only way would be to put the logic to determine
"File/Directory not found", "Dir confirmed" and "File confirmed" into the
query. You could try creating a function that returns the value and calling
the function in your query, but you could run into problems, depending on
the Sandbox Mode under which you're running.

 

[Vylent Fyre]

Please forgive my tardiness in this reply; it's month end close around here
and it's a quarterly one, plus the director of accounting is out on vacation
so it's been crazy hectic around here! =)

I can't figure out how to change it (Sandbox mode) since I am not able to
change the macro settings (to low) at this time. I'm running Access 2002 so
I am not for certain it would apply to me.

I am in the middle of trying to incorporate this logic into an expression in
a query at this time - I'm not having much luck because it keeps kicking back
saying "Dir" is an invalid function. This is what I have (I'm sure it's not
right obviously)


File Confirmed:
IIf(Len(Dir(HyperlinkPart([Scanned_JE_Link],[acAddress])))=0,"File Not Found")

 

[Douglas J. Steele]

Check http://support.microsoft.com/kb/294698

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Please forgive my tardiness in this reply; it's month end close around
here
and it's a quarterly one, plus the director of accounting is out on
vacation
so it's been crazy hectic around here! =)

I can't figure out how to change it (Sandbox mode) since I am not able to
change the macro settings (to low) at this time. I'm running Access 2002
so
I am not for certain it would apply to me.

I am in the middle of trying to incorporate this logic into an expression
in
a query at this time - I'm not having much luck because it keeps kicking
back
saying "Dir" is an invalid function. This is what I have (I'm sure it's
not
right obviously)


File Confirmed:
IIf(Len(Dir(HyperlinkPart([Scanned_JE_Link],[acAddress])))=0,"File Not
Found")

I believe the only way would be to put the logic to determine
"File/Directory not found", "Dir confirmed" and "File confirmed" into the
query. You could try creating a function that returns the value and
calling
the function in your query, but you could run into problems, depending on
the Sandbox Mode under which you're running.