Group:  Microsoft Access ยป microsoft.public.access.externaldata
Thread: how to detect if file exists

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

how to detect if file exists
JB 06.06.2006 11:04:01
Is there any way to detect if a file exists?

I want my database to display a command button only if file "export.csv"
exists on the server.
Re: how to detect if file exists
"Rick Brandt" <rickbrandt2[ at ]hotmail.com> 06.06.2006 11:42:14
"JB" <JB[ at ]discussions.microsoft.com> wrote in message
news:8FF456C6-AC39-4B4B-96A4-5A4324BAC06F[ at ]microsoft.com...
[Quoted Text]
> Is there any way to detect if a file exists?
>
> I want my database to display a command button only if file "export.csv"
> exists on the server.

Dir("full path to export.csv")

Will return "export/csv" if the file exists and "" if it does not.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net