Hyperlink question

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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....
 
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.
 
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")
 
Check http://support.microsoft.com/kb/294698

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


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