-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Èçâëè÷åíèå ôàéëîâ èç ïîëÿ "Âëîæåíèå" ïðîãðàììíûì ïóòåì

Âòîðíèê, 29 Àïðåëÿ 2014 ã. 13:08 + â öèòàòíèê
Äîáðîãî âðåìåíè ñóòîê ôîðóì÷àíàì!

ß èçâëåêàþ ôàéë âîò òàêèì êîäîì:
Public Function ExportAttachment() As String
Dim i As Integer
Dim f
Dim path
Dim fil
Dim filp
Dim filK
f = Forms!frm_mail!attach.FileName
If f = "" Then GoTo ex
path = "C:\SedMO\TEMP\OutPut\dfiles\"
fil = Dir(path)
filp = path & fil
If f = fil Then Kill (filp)
Dim strSQL As String
 i = Forms!frm_mail!ID_mail
strSQL = "SELECT * FROM [td_mail] WHERE [id_mail] =  " & i
 
Dim strFilePath As String
Dim db As DAO.Database
Dim rsParent As DAO.Recordset2
Dim rsChild As DAO.Recordset2
 
Set db = CurrentDb
 
Set rsParent = db.OpenRecordset(strSQL)
 
rsParent.Edit
Set rsChild = rsParent.Fields("attach").Value
 
      rsChild.Fields("FileData").SaveToFile "C:\SedMO\TEMP\OutPut\dfiles\"
    ExportAttachment = rsChild.Fields("FileName")
    
ex:
Exit Function
End Function


Ýòîò êîä ñî ñâîåé çàäà÷åé ñïðàâëÿåòñÿ, òîëüêî åñëè â ïîëå âëîæåíèå òîëüêî îäèí ôàéë.
Êàê ìîæíî èñïðàâèòü êîä ÷òîáû îí èçâëåêàë âñå âëîæåííûå ôàéëû?
Ïîìîãèòå ïîæàëóéñòà êòî çíàåò!

http://www.sql.ru/forum/1091943/izvlichenie-faylov-iz-polya-vlozhenie-programmnym-putem


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó