Find the directory part (minus the filename) of a full path in access 97

July 22, 2023 by Tarik

You can do something simple like: Left(path, InStrRev(path, "\"))

Example:

Function GetDirectory(path)
   GetDirectory = Left(path, InStrRev(path, Application.PathSeparator))
End Function