microsoft.public.access.forms

I put in the entire path and it worked. Expecting the same, I substituting
the text box name for "FullpathToFile" and it didn't.
--
AusTexRich


"Douglas J. Steele" wrote:

> Substituting a text box name would mean that you'd be able to test whatever
> file name is contained in that text box. You'd still have to loop in order
> to test each link.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "AusTexRich" wrote in message
> news:4CA34565-CA3A-4909-8573-0EDA8F464B7D@microsoft.com...
> > Thanks. That's what I'm asking. Now, do I substitute my text box name
> > for
> > "FullpathToFile" or do I have to test each link individually?
> > --
> > AusTexRich
> >
> >
> > "Douglas J. Steele" wrote:
> >
> >> If you're trying to determine whether or not a given file exists, you can
> >> use
> >>
> >> If Len(Dir(FullpathToFile)) > 0 Then
> >> ' File exists
> >> Else
> >> ' File doesn't exist
> >> End If
> >>
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "AusTexRich" wrote in message
> >> news:235F25C8-AC44-4B96-8255-A7DD585A6F05@microsoft.com...
> >> > Surely Access has a way to detect if a file actually exists without
> >> > having
> >> > to
> >> > open each hyperlink. I'm using a continuous form and have a hyperlink
> >> > to
> >> > a
> >> > file for each record. It'd be real convenient to indicate on the form
> >> > whether or not the file is actually there. Is that possible to do?
> >> >
> >> > Thanks
> >> > --
> >> > AusTexRich
> >>
> >>
> >>
>
>
>