View Single Post
Old December 18th, 2009, 10:25 AM
RodM RodM is offline
Authorized User
Points: 71, Level: 1
Points: 71, Level: 1 Points: 71, Level: 1 Points: 71, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jan 2009
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
Default Delete files with command button

I created a personal household inventory database for homeowner's insurance purposes. Each record contains data related to a household item such as a TV, table, etc. Each item has two associated .jpg files which show a photo of the item and related documents. These .jpg files are in the same folder as the database .mdb file. Each record contains an ItemNumber field and I assign each household item a unique number such as AP001. Each .jpg file is similarly named such as AP001.jpg and AP001-Doc.jpg. I placed a command button on my form to delete records no longer needed but must manually delete the associated .jpg files. When I click my command button to delete a record I want to automatically delete the .jpg files as well. Any help would be greatly appreciated.