Remove specific type of attachment from all records in table

[progamer]

Hi There,



I have table call "empTable" and it has an Attachment field called "Attachment". Some of the records has empty Attachment field and some record has one attachment and some has two and the attachment types are jpeg and pdf.

I want to remove all the pdf from all the records in this table automatically with VBA or something, is it possible?

Can anyone post the code for how to do it?

[June7]

Review https://www.accessforums.net/program...ent-23686.html

[progamer]

June7,

My problem is different, I want to delete all the pdf attachments from all the records of the table.

[June7]

Yes, and a site linked in that thread has code that can be adapted to accomplish that. I am having problem opening that site but it was good a week ago. Must be my lousy internet at home.

http://blogs.office.com/b/microsoft-...cess-2007.aspx