FoxPro JustFName() function

The VFP JustFName() function returns the name of a file complete with its extension.

JustFName ("C:\Microsoft Visual FoxPro 9\vfp9.exe")

would return:

"vfp9.exe"

Use the JustStem() function if you want the stem of the filename without any extension.

VBA equivalent

Microsoft Access does not have equivalents to these FoxPro file name commands so I wrote this library Visual Basic functions to do give me the same facilities in VBA.

FoxPro Functions

FoxPro has always had functions like FREAD and FWRITE to read and write files at a low level. They can handle files which defeat the STRTOFILE and FILETOSTR functions.

FoxPro DefaultExt function

FoxPro functions to manipulate names of files and folders

FoxPro ForceExt function

FoxPro functions to manipulate names of files and folders

FoxPro ForcePath function

FoxPro functions to manipulate names of files and folders

FoxPro JustExt function

FoxPro functions to manipulate names of files and folders

April 2012

Windows 7 doesn't support FoxPro 2.6 but we've got it running nicely by installing VirtualBox. and then loading Windows 2000. Good to see the old Windows 2000 Pinball game again too.

FoxPro and Access database support from Alvechurch Data

Access and FoxPro development from Alvechurch Data

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro database training and development

Phone us on 0121 445 1300, email sales@alvechurchdata.co.uk , or use our contact page