Any idea's on how to make these statements any shorter?
Code:
strDrive = iMBS.DBPath
strDrive = (Left(strDrive,1))
strDrive = Replace(strDrive, strDrive, strDrive & "$")
strPath = iMBS.DBPath
strPath = Right(strPath,Len(strPath)-2)
strNetPath = strDrive & strPath