FileSystem

[PeterL]

I am trying to verify that a file exist. The file will always be named the same and in the same location. I am using the following code without much luck. Any thoughts as to my error.

If FileSystem.Dir("c:\FromCounter.txt") <> "" Then
DoCmd.Close acForm, "AboutForm", acSaveYes
End If

 

[Blorf]

Hi. Try insted

If Dir("C:\FromCounter.Txt") = "" then
DoCmd.Close acForm, "AboutForm", acSaveYes
End if

 

[PeterL]

I bow to the guru.

 

[Blorf]

Glad to help.

ChaZ