SteveClarkson
Registered User.
- Local time
- Today, 14:53
- Joined
- Feb 1, 2003
- Messages
- 439
Hello,
Long time, no post!
I have a form with an Attachment field on it - this field is used to store user photographs. Once in a while, these pictures are updated, but the old ones are retained too. They follow the naming convention of: CCYY_MM_DD_HH_MM_SS.jpg
When there is a single photo in there, it's great - you open up that users record, and it shows their photo, lovely.
If they have a newer picture added, because of the naming convention, they are ordered from lowest to highest - and with the naming convention in use, this puts the newest photos at the bottom of the list - and so the "default" picture shown is actually the oldest one.
I can't seem to find a way to 'encourage' Access to change the order it displays these attachments in - any ideas?
Running Access for Office 365 (v16)
Thank you,
Steve
Long time, no post!
I have a form with an Attachment field on it - this field is used to store user photographs. Once in a while, these pictures are updated, but the old ones are retained too. They follow the naming convention of: CCYY_MM_DD_HH_MM_SS.jpg
When there is a single photo in there, it's great - you open up that users record, and it shows their photo, lovely.
If they have a newer picture added, because of the naming convention, they are ordered from lowest to highest - and with the naming convention in use, this puts the newest photos at the bottom of the list - and so the "default" picture shown is actually the oldest one.
I can't seem to find a way to 'encourage' Access to change the order it displays these attachments in - any ideas?
Running Access for Office 365 (v16)
Thank you,
Steve