[AccessD] OpenFileDialog multiselect order

[Rocky Smolin]

This may be a bit elaborate but you could create either a temp table where the first field is numeric data type and  contains everything to the left of the - in the file name.  Second field contains the file name.  Import the files in numeric order by opening the temp table using a query which sorts on the first field.

HTH

Rocky

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ryan W
Sent: Wednesday, May 01, 2019 7:53 AM
To: Access Developers discussion and problem solving
Subject: 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.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com