Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010

    Unanswered: How do I save "Attachment" objects automatically

    Hi, I have a need to output a list of about 22000 entries, each one with a JPG attachment, into a directory (i.e. save every attachment of every entry back into a file)

    However, there doesn't seem to be any immediate ways to do this other than clicking on each entry, then clicking on its attachment, and then clicking "save as".

    It would seem sensible that there must be an code specific way to do it, seeing as that functionality is already coded in the attachment "Save As" button. Is there anyway to invoke that function automatically?

    Thank you

  2. #2
    Join Date
    May 2010
    I assume you are working with Access 2007/2010 and the new attachment feature.

    I recommend reading this:

    Microsoft® Access 2007 Working with the Attachment DataType

    Also please read: A message to forum cross posters
    Last edited by HiTechCoach; 08-06-10 at 14:15.
    Boyd Trimmell aka HiTechCoach (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Aug 2010
    Admittingly I've cross-posted (How to save "Attachment" objects automatically - Access World Forums) .

    Thank you very much for the answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts