Recent content by Albert2

Very graphic and clear! I did several tries trying to execute the vba at the same time and I had abbandoned the project for a while. Thanks!

Thanks for your clarification @Pat Hartman I'll do my best!

Hi @Pat Hartman, I've tried I have modified all the Item# to unique, changing all the values counting 10. · In your Access you can not introduce a number that is allready in the table, but when you apply the vba to renumber it also give an error. I should have more time to look into. Keeping...

HI @Mike Krailo, I must check your examples carefully, it could save me time. Hi @Pat Hartman, It looks the issue could come from the "non duplicate" option independently of the key. Maybe there's something I miss. PD: I was trying to copy the resorted values to a none indexed field (with...

Yes, this is the reason it doesn't work, I'm applying the vba "AfterUpdate" and when I enter the repeated number to renumber the whole sequence without duplicates Access detects the error. I have made several tries to avoid it: copy order, disconnect and reactivate the unique index and copying...

Thanks @Pat Hartman. Those are nice solutions when you can use duplicates on your reordered field. Meanwhile, the easiest solution will be to eliminate the table "chapter" and integrate the field "chapter" inside the table "titles" and apply the chapter update query just to that title. I'll...

There's already a thread for Maintaining Custom Sort Order but just for one table by @Mike Krailo What I'm looking for is also the capability to change the order of a field by the user. The attached vba replace the chapter number but when I change the property Indexed to unique values it...

I just wanted to follow the related question without opening a new one. Thanks for your suggestions! I'll do it!

It's possible in case the field has no unique values requirements, as below. Tot explain what it does: In this case letters are title names and numbers position A=1,B=2.C=3,D=4,E=5, user modifies the A=3 and the rest of titles change to B=1,C=2,A=3,D=4 y E=5. But someone know how to apply the...