Function Check If Folder Exists

Function Test If Folder Exists VBA Code: Function FolderExists(sFile As Variant) As Boolean On Error Resume Next If Len(sFile) > 0 Then     FolderExists = (Len(Dir$(sFile, vbDirectory)) > 0&) End If End Function How to Use It: Put the VBA code above on form or in the Module and call it on the click button on your Access file where you want to check if this form exists before call process the next step. If you call a certain folder or file path that does not exist then you will get…

Read More