deleting corresponding filename

[Bob]

I have a photo database that has a table:
_________________________
pic_filename (which corresponds to an actual filename
*.jpg that is displayed in a form).

description (memo field for searching)

and some other anomalous fields.
__________________________
I'm able to automatically create new records after
checking for new filenames in a specfic directory, but...

now I need to delete a current record on a form and it's
corresponding jpg. How do I do this?


v/r bob

 

[Douglas J. Steele]

You can use the VBA Kill statement to delete the file:

Kill "C:\My Pictures\Image123.jpg"