Hi
I am trying to write some VBA code which iterates through a table ("tblPlayers") and specifically looks at two fields (Photo and PhotoNew). The code should look at a folder of images and based on the filename (which should match the names in a field called PlayerName it should add the image into the PhotoNew field for that record before moving on. If a photo isnt found then it is just skipped.
My issue is that whilst iterating through is easy enough I cant seem to find any documentation for adding and deleting files attached to a field in access via VBA.
Normally Google is my friend here but not this time and as access doesn't have the lovely macro recorder so i can figure it out that way Im slightly lost. I was trying rs.Fields("PhotoNew"). but then none of the options when i add the next '.' are suitable i think and changing it to something like rs.Fields("Photo").Value = "" (for deleting) returns Item not found in collection.
Thanks in advance.