I have a form where users can attach files to the record. When they attach multiple files at once (i.e. hold down the shift key and double click) the first attachment shown is the last one clicked on. For example if there are five files the user wants to attach to the record named 1,2,3,4,5 - they click on 1, hold shift and click on 2,3,4,5,. In order to attach all the files at one they have to double click on 5. When the files are attached in Access they are attached as 5,1,2,3,4. Does anyone know if it's possible to get multiple files to attach in a defined order, such as the date the file was created? I don't want the user to have to attach one file at a time to get them in the order they want them.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 07 Attachment Field
- Thread starter cer5yc
- Start date
Similar threads
