The following returns the MS Access Application Path.
Dim WRK_EXECUTABLE_PATH_210 As String
[WRK_EXECUTABLE_PATH_210] = Application.CurrentProject.PATH
I want to extract the text "M:\Pgm\01-MDB-Design\SAS" from the above result where 'Source' could be any string value. i.e. I can't use the Left or Mid Functions.
I'm doing this within a Form Event procedure.
How do I do it?