ACCESS FEED: [MS_AccessPros] Work with PDF in ole fields

Minggu, 22 September 2013

[MS_AccessPros] Work with PDF in ole fields

Hi all, here a nice sun (North Italy).

I'm working on ole field where people drag and drop PDF. I know it is not an elegant solution, but it is fast simple for my people up to now.
Now, I was looking to work with the ole field, and in particular I would like to take the object inside (a pdf), rename it, and save it in a specific path.
I found some solution thnaks to the BigBrotherGoogle, but only one make sense and it need a DLL to extract the object [http://www.lebans.com/DownloadFiles/ExtractInventoryOLEver89.zip]
To rename and move the file I usually use this procedure:
code renamingProcedure-START----------------------------------------
Dim OldName, NewName
' checking if file exist already
If Len(Dir([Newdir] & "\" & [NewNomeFile0])) > 0 Then
' delete the file if exist
Kill ([Newdir] & "\" & [NewNomeFile0])
' REnrename and move the file nowd If
OldName = [DocPath]: NewName = [Newdir] & "\" & [NewNomeFile0]
Name OldName As NewName
DoCmd.RepaintObject acForm, "FileRinomina"
If Len(Dir([Newdir] & "\" & [NewNomeFile0])) > 0 Then
VerificaFile0.Visible = True
DocPath = ""
End If
code renamingProcedure-END----------------------------------------
but I need the file, and if I try to work with OLE, of course it is not working...

Any idea or experience on files in OLE field?
Thanks in advance.
Ciao!