Any easy way to get an attachment's file name?

[dillopk]

I have a table whose records contain attachments of jpg files. (Yes I know this can make my database very large.) The names of the attached files, which are created by the camera, contain date information I would like to extract. For example, an attached file is named "IMG_20160725_150253293.jpg" (without the quotes). Is there an easy way to get that name into a text field so I can use LEFT, MID, etc to get the year, month, day etc. that that camera assigned? My goal is to extract the date from the file name instead of having to enter it. By the way there is only a single attachment per record.

[ranman256]

The attachment is a recordset,so
set rst = currentdb.openrecordset([field])
sPath=rst.field(0)

Yr= mid(sPath,5,4)
mo= mid(sPath,9,2)
Day= mid(sPath,11,2)