microsoft.public.access.forms

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
>>
>>
>>