Linking Files

[Learn2010]

We are trying to find a more efficient way to link files to a record via a form. Currently, we save the files with today’s date, record number, and a short description. For example, one saved there today may be like this: "5-9-17 56789 Order."

I have a process set up to allow the users to link to the files. They open a form with two fields in it. Field 1 is a description field. Field 2 is a hyperlink file. The process is this:

Right click on Field 2
Left click on Hyperlink
Left click on Edit a Hyperlink

This opens the folder where the database resides. I have the users go up one level using the icon located there to get to the folder where the files are stored. The testing I have done seems to put the last files entered at the bottom of the list. It won’t take long for this list to get very long. I would like to have the files displayed in descending dated order so the first file there will be the one they need.

Is there a way to have them sort as I suggested?

Thank you.

 

[sxschech]

As far as naming convention, for sorting purposes it might be better like this? If you want to keep all together by type. Also better to not have spaces and dashes.

Order_56789_20170509

 

[Learn2010]

Thank you for your quick response. Type of file here is not important. The sort process has first priority. I would simply like the last in to be at the top of the list when making the link. They will be making the link immediately after saving it into the storage folder. Once the file is linked they will no longer have a use for locating it again. If they need the file it will be in the record. When opened it will be in its native state.

 

[sxschech]

If the name is known ahead of time and only the date part changes, we could probably code that to get the most recent file. You mentioned hyperlink are you actually linking the file into an access table or using the hyperlink to open the external file for viewing?