Q: FileExits

[JIM.H.]

Hello,

It seems If FileExits (“FilePathNameâ€) does not work if I have
FilePathName=â€c:\Doc\*.txtâ€

How can I check if any *.txt exists in the c:\Doc\ in my code?

Thanks,

 

[Ofer]

Check this prev post on the same subject

http://www.microsoft.com/office/com...nfig&mid=c5436fa7-f82c-4092-b53c-baa206aa4221

 

[Van T. Dinh]

I think you meant FileExists, NOT FileExits.

You cannot use wildcards with FileExists. Check Access VB Help on the Dir()
function instead.

 

[TC]

if dir$("C:\doc\*.txt") = "" then
' none.
else
' some.
endif

HTH,
TC