Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
FoxPro JustPath() function
The VFP JustPath() function returns the path to a file or a folder.
would return:
JustPath() will also accept the name of a folder and will return the path to that folder. There is however a subtle difference in its behaviour depending on whether the folder name ends with a backslash. If there is no backslash then you get the path to that folder:
would return:
But if there is a already a final backslash then you would get the same folder name returned with the backslash removed:
returns
Unlike the JustDrive() function, JustPath() will operate safely on network drives and on paths containing forward slashes:
would return:
and
would return:
VBA equivalent
Microsoft Access does not have equivalents to these FoxPro file name commands so I wrote this library of Visual Basic functions to give me the same facilities in VBA.