[AccessD] OpenFileDialog multiselect order

[Gustav Brock]

Hi Ryan

If not, you could write a tiny function in VBA to carry out the task - on a copy of the files if needed.

/gustav


-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Ryan W
Sendt: 1. maj 2019 16:53
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] OpenFileDialog multiselect order

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.
>