Access, form list, re-order priority
Access 2003.
I have a form with a continuous list which will hold titles of projects. I need to be able to designate a priority to each, and then be able to change those priorities so that the previous number one is now number two if I designate a new number one. In other words, the number of priority will go up or down based on what priority you assign to another project. The reason for this is so we don't have to manually change the priority's when a new project is added or re-prioritized, trumping or being below another. Whatever was 6 is now 7 if we prioritize something new as 6... whatever was 9 is now 8 if we designate a new 9.
Possible?
I have a form with a continuous list which will hold titles of projects. I need to be able to designate a priority to each, and then be able to change those priorities so that the previous number one is now number two if I designate a new number one. In other words, the number of priority will go up or down based on what priority you assign to another project. The reason for this is so we don't have to manually change the priority's when a new project is added or re-prioritized, trumping or being below another. Whatever was 6 is now 7 if we prioritize something new as 6... whatever was 9 is now 8 if we designate a new 9.
Possible?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Am I losing my mind or did part of this thread disappear?
ASKER
PatHartman,
If you mean did the OP disappear, I am still here but got sidetracked and haven't had time to try any of these. I will get back involved later today.
If you mean did the OP disappear, I am still here but got sidetracked and haven't had time to try any of these. I will get back involved later today.
Pat, I think you are perfectly alright ... but this thread (where I originally posted the code) has been idle while the other (link above) moved ahead.
/gustav
/gustav
Can we get one of the threads closed? There shouldn't be two active on the same topic.
ASKER
? I don't have two threads open on this topic.
The tasks to be resolved happened to be 99% identical.
However, the authors are not identical.
/gustav
However, the authors are not identical.
/gustav
In the other thread I asked if this was a school project and was informed that it was not but a co-worker had posted the same question. QMBB, perhaps you and your co-worker can collaborate so we don't have to answer the same question twice in the same day. Unless of course, you think you'll get different answers.
ASKER
Ah, I see what your're talking about... the same type of project was up at the same time, and we both grabbed one. I didn't know he was working on the other one... we obviously have some tightening up to do as far as workflow.
I will close this thread asap.
I will close this thread asap.
https://www.experts-exchange.com/questions/28539648/Re-Order-fields-in-a-table.html?anchorAnswerId=40396231#a40396231
/gustav