Ïðîâåðèòü ñóùåñòâîâàíèå ïàïêè ïî íåïîëíîìó íàçâàíèþ
|
|
Ïîíåäåëüíèê, 25 ßíâàðÿ 2016 ã. 13:48
+ â öèòàòíèê
Äîáðûé äåíü!
Åñòü áàçà äàííûõ êëèåíòîâ þð.ëèö. Íà ôîðìå â ÷èñëå ïðî÷åãî åñòü ïîëÿ "ÈÍÍ" è "Íàçâàíèå". Èìååòñÿ êíîïêà "Ïàïêà" êîòîðàÿ îòêðûâàåò ïàïêó â åêñïëîðåðå ñ äîêóìåíòàìè ïî ýòîìó êëèåíòó. Ïðè íàæàòèè íà ýòó êíîïêó ïðîâåðÿåòñÿ íàëè÷èå íà äèñêå Z ïàïêè ñ íàçâàíèåì ðàâíûì ÈÍÍ - åñëè òàêîé ïàïêè åùå íåò, òî îíà ñîçäàåòñÿ - è îòêðûâàåò ýòó ïàïêó.
Âîò êîä îí ïðåêðàñíî ðàáîòàåò:
Private Sub cmdFolder_Click()
Dim INN As String
Dim fso As New FileSystemObject
INN = Me.Controls("ÈÍÍ").Value
If fso.FolderExists("Z:\" & INN") Then
Shell "explorer Z:\" & INN, vbNormalFocus
Else
fso.CreateFolder ("Z:\" & INN)
Shell "explorer Z:\" & INN, vbNormalFocus
End If
End Sub
Íî ïðè òàêîì ðåøåíèè ñëîæíî èñêàòü ïàïêè âðó÷íóþ (íå ÷åðåç àêñåññ)
Çàäà÷à - ÷òîáû ïàïêè íàçûâàëèñü ÈÍÍ + ïðîáåë + Íàçâàíèå ( à ëó÷øå íàîáîðîò (Íàçâàíèå + ïðîáåë + ÈÍÍ)
Ñîçäàòü òàêóþ ïàïêó ïðîáëåìû íåò:
fso.CreateFolder ("Z:\Imhotep\" & INN & " " & FirmaS)
Âîò òîëüêî óäàëèòü çàïðåùåííûå ñèìâîëû íàäî (êàâû÷êè è ñëýøè) - âîò âîïðîñ
À ãëàâíîå, êàê ïðîâåðèòü ñóùåñòâîâàíèå òàêîé ïàïêè è îòêðûòü åå ïðè óñëîâèè ÷òî íàçâàíèå â áàçå (ïîëå íà ôîðìå) ìîæåò êîððåêòèðîâàòüñÿ è âîîáùå íå áóäåò ñîîòâåòñòâîâàòü íàçâíèþ ïàïêè (èç-çà óäàëåííûõ â íàçâàíèè ïàïêè êàâû÷åê íàïðèìåð)
Ãðóáî ãîâîðÿ: Êàê Like çàïèõíóòü â Shell è â FolderExists
Çàðàíåå ñïàñèáî!
http://www.sql.ru/forum/1197087/proverit-sushhestvovanie-papki-po-nepolnomu-nazvaniu
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-