Can someone assist me in my search for a function or coding.
Here is the description,
I have several hundereds of pictures that are grouped in categories. I want to be able to put the pictures in a viewable order state say I think one picture should come up first and the other in order. Example pic1 =1 pic3 = 6
pic4 = 2 thus displaying pic1, pic4, pic6 and so forth. Now I know that I change the sort order when setting the recordset to sort by the field. The problem stemming is about how to get the grouped pictures to allow for a one page all number change. I know you can't hit the database to update all records so they must be done one at a time. I am not a pro at coding the routine therefore I am asking for some suggestions and examples.
Thanks guys!
Here is the description,
I have several hundereds of pictures that are grouped in categories. I want to be able to put the pictures in a viewable order state say I think one picture should come up first and the other in order. Example pic1 =1 pic3 = 6
pic4 = 2 thus displaying pic1, pic4, pic6 and so forth. Now I know that I change the sort order when setting the recordset to sort by the field. The problem stemming is about how to get the grouped pictures to allow for a one page all number change. I know you can't hit the database to update all records so they must be done one at a time. I am not a pro at coding the routine therefore I am asking for some suggestions and examples.
Thanks guys!