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.
March 2015
I have now retired and am taking on no new work. I'd like to thank all our customers over the past 20 years. It really has been a most enjoyable time.
FoxPro ForcePath function
The VFP ForcePath() returns the filename with the specified path replacing any existing path.
For example:
would return
This function is useful when you want to make a backup of a file in a new folder. You can use the GetDir fuction to ask the user for a new path then use ForcePath to add this to the file names that you want to copy.
Note that FoxPro will not check whether the path specified exists or even if it is a correctly formed path name.
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.
