[AccessD] OpenFileDialog multiselect order

[Ryan W]

I'll have to see if that's possible, the filenames are auto generated out
of another piece of software.


On Wed, May 1, 2019 at 9:46 AM Gustav Brock <gustav at cactus.dk> wrote:

> Hi Ryan
>
> Rename the files to 02-File.txt, 03-File.txt etc.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Ryan W
> Sendt: 1. maj 2019 16:40
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Emne: [AccessD] OpenFileDialog multiselect order
>
> Is there a way to control the MultiSelect order when selecting files?
>
>
> Say we have files:
>
> 2-File.txt
> 3-File.txt
> 4-File.txt
> 5-File.txt
> 6-File.txt
> 7-File.txt
> 8-File.txt
> 9-File.txt
> 10-File.txt
>
> If you click 2-File.txt and hold shift and select 10-File.txt, it selects
> them all but then in the Filenames list below the file list, it shows the
> order as 10-File.txt, 2-File.txt, 3-File.txt (etc).
>
> So when the files get imported into the DB, 10-File.txt gets read in first
> which changes the sequence of how we want the data imported.  Right now the
> 'workaround' is import 2-9, then come back and get 10+.
>
> This is with Access 2013, though I don't think the version matters much.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>