[AccessD] OpenFileDialog multiselect order

[Gustav Brock]

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.