How To Save any attachment to folder Outside My Database (1 Viewer)

[a7mad1990]

i need code vba to save any attachment to folder outside my database "Behind DB File" called "Attachments"
i have 4 fields on my Form "FrmWeeklyRep" and i need to save the attachments to folder outside my database
and i have 1 field on my Form "FrmOrder" and i need to save the attachments to same folder with subfolder called "AttachmentTransfere" outside my database

i need to save the attachment with his "original name+Currunt Data" filename

i need vba code to save it out side my DB Not on my BD So you don't get too big DB file with me

thanks For All

 

[Gasman]

See Similar threads at the bottom of this post.

 

[a7mad1990]

This does not match what I mean in my topic

 

[June7]

And why not? At least one of the thread titles looks appropriate to me.

Review https://learn.microsoft.com/en-us/o...a-Access-Objects/work-with-attachments-in-dao

 

[Pat Hartman]

You keep referring to these "things" as attachments. That has a specific meaning. Attachments are files that you have loaded as attachments into your Access database. Are you talking about exporting them from your .accdb and storing them as normal files in some server-side folder? And if so, why doesn't the link provided by @June7 work?