Finding Drive letters
Posted: Wed Nov 10, 2004 4:28 am
Kathleen,____I have two offices which has the same software installed. They are using Foxpro based database.____The database is residing in one site on H: drive and in trhe other site it is I: drive____I am in the process of writing couple of reports common to each of the sites. All I have to do is to change the heading, and couple of lines specifically for each of the property.____Now I have two ways of distributing these reports. One, write two reports one for each and distribute. Two,write a common report and have the specific titles being introduced on a conditional line. The second approach will greatly reduce the confusion I have in assigning drive letters and paths as well as heading and other info.____Is there any way, I could identify the drive letter on which a particular folder is located and based on that could activate the lines?____Example: If the main database is located in H: drive, can a condition or series of conditions be introduced into R&R report, which will locate the drive letter and if it is H:,then print "This is drive H" or if it locates drive I: then print "This is drive I:"?____Would appreciate if you could guide me on this.____