Selecting and Moving Records

[gselliott]

Is there anyway of setting up a form that would allow the user to select a record and manually move the position of that record. e.g. A record with the a Client Code of 111 is currently at position 10 in the table and you want to move it to position 2. I cannot use the sorting tools from within Access as the sorting needs to be set out in a specific way.

The reason I need this is because I am currently exporting a query into a txt file from the database which contains Invoices these are read into another 3rd party program. I need to ensure that no two lines of the txt file are grouped together with the same client code as this causes problems within 3rd Party program.

I am guesing that this won't be possible but if anyone has got any ideas I would be very greatful as I am getting a great deal of hassle from the users!

Thanks

 

[dcx693]

How is your query being sorted, if at all? It sounds like it's not, and that you're depending on the record position within the source table. If so, that's an unreliable way of "sorting" the records because tables are, by definition, unsorted.

It sounds like you might need to even manually sort these records by inserting your own numeric "position" field into the table.

 

[ghudson]

You can not do that. I would suggest adding another field to your table that allows you to manually number each record. You can then use a query [sorted by the new field] to transfer the data as a text file. Odviously you would not include the new field as part of the output, you would just be using it to sort the data.

HTH

 

[gselliott]

Thanks for your replies, dcx693 you are right the query isn't being sorted at all, I know this is unreliable but if I were to have sorting set the output would not be what the user wants.

I guessed that there wouldn't be a way of allowing the user to click the record and move it to its desired position (was living in hope!) I think I will have to use another field that is used to manually number the record.

Thanks for your help though it is much appreciated. if anyone does have another ideas then please feel free!

Thanks again!