Search results

Hi jdraw, I changed the immediate window to Call ExtractAllBLOBS("tblBlobtest","BlobField","E:\TempImages\","filename") and was able to extract the file but the extracted image says it's an unknow format. I tried a .jpg, jpeg and .bmp file and they all say they are unknow formats. Good news...

Hi jdraw! Thanks for the info!! I made basic table as mentioned and pasted the code in the module but got the below debug message: Run-time error '75: Path/File access error Debug stops at: 150 Open FullOutputFile For Binary As #intFileNum The table I made was: tblBlobTest...

Hi guys, I have a code to extract the Attachment field of a table but would rather extract the OLE Object field. How can I change the script to pull the OLE Object ([Image]) instead of the Attachment field ([GenImage]). Here is table data: LeadersDBList...

Works perfect now! :) I just need to change the field "Unit Name" to"Unitcard". That was my mistake! THANK YOU, arnelgp. Greatly Appreciated!!

arnelgp, I pasted the code in the module but no luck. the 2 files export were only the name of the attachment, not relabeled as the [Unitcard] fields. LeadersDBList DSTATESizeUtypeGenSideNationFolderUnit NameUnitCardImageGenImage 1BulgarianDepartmentLeaderRebel GenearlBulgarianDepartment...

When I try somethign like this it doesn't work. Do Until rsAttachments.EOF Dim outputFileName As String outputFileName = rsAttachments.Fields("FileName").Value (Changed it to.... .Fields("UnitCard").Value but that didn't work)...

I updated the "Code" text correctly now. Thanks for pointing that out. I am able to successfully export the attachments for each line but want to rename the files with the name of the field [Unitcard] & .bmp. That' where I'm stuck. Export works great but many of the attachments are the same...

Thanks for the quick feedback guys! Much appreciated!. The key issue isn't being able to extract the attachment file. The issue is I want to rename the file as the name of column [Unitcard]. Currently it exports it and names the file as the original attachment name. I'm not sure how to...

Hi guys! I'm trying to export attachments from my table and relabel the file as the name from a column from the table [UnitCard]. Currently it exports them as the name of the attachment. Here are the column names: LeadersDBList IDSTATESizeUtypeGenSideNationFolderUnit...