Picking up image names from folders

[DennisJones]

I have an application which dumps jpg images in a folder on demand, they do not overwrite each other and can be created for example, with date and time stamps in their file names. I want to be able to pick up the name of the latest image and store a link to it in a access form so that it can be associated with and then displayed on the form with it's matching record details. Can anyone tell me how I can can pick up the most recent filename in a folder?

Thanks

 

[DCrake]

You would have to write a function that takes the prefix of the file name and trawl throuth the folder for matching files copying them into an array for example then using the CDate() function on the date/time stamp part of the field name evaluate which has the latest date/time. then once established this file becomes the most recent one is updated accordingly in the database.

In Theory that is.