Bob Collison
asked on
Find first 'character' from right in a string.
The following returns the MS Access Application Path.
Dim WRK_EXECUTABLE_PATH_210 As String
[WRK_EXECUTABLE_PATH_210] = Application.CurrentProject .PATH
Example :
M:\Pgm\01-MDB-Design\SAS\S ource
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?
Thanks.
Bob C.
Dim WRK_EXECUTABLE_PATH_210 As String
[WRK_EXECUTABLE_PATH_210] = Application.CurrentProject
Example :
M:\Pgm\01-MDB-Design\SAS\S
I want to extract the text "M:\Pgm\01-MDB-Design\SAS"
I'm doing this within a Form Event procedure.
How do I do it?
Thanks.
Bob C.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER