I don't know if this is possible or not and if it is, it seems it may be a bit out of my leaugue but here it goes:
I have a database in Access 97.
Multiple users. It is set up with records on a continuous form and when a person on the team goes in to work on an item, they select their name from the drop down box, this way everyone else knows someone is already working it. When they work the item there is a seperate drop down box that they can select the action taken and then either change it back so another person in the group can work it further sometime down the road or, if they complete it, they can just keep it in their name.
What often happens is team members (despite numerous requests to watch this) will sometimes take one in their name and then do nothing with it. Now it is sitting in their name so noone thinks to look at it and there are cases where it "disappears" from our radar because we assume it is assigned and being worked.
I am looking to place a "timer" of sorts on the records where if the action drop down does not change after ...say an hour...it will automaticly switch back to the team designation so somone else can pick it up. Or better yet...if I could put a check box to indicate a record for them to keep and if THAT is not checked it would revert to the team designation after about an hour or even at the ned of the day would be acceptable.
Right now I am going in and checking each one and assigning them back out but that is terribly time consuming.
Is there any solution for this?
My Access skills are acceptable but by no means Pro level.
Even just telling me it's not possible will be appreciated.
Thank you.
I have a database in Access 97.
Multiple users. It is set up with records on a continuous form and when a person on the team goes in to work on an item, they select their name from the drop down box, this way everyone else knows someone is already working it. When they work the item there is a seperate drop down box that they can select the action taken and then either change it back so another person in the group can work it further sometime down the road or, if they complete it, they can just keep it in their name.
What often happens is team members (despite numerous requests to watch this) will sometimes take one in their name and then do nothing with it. Now it is sitting in their name so noone thinks to look at it and there are cases where it "disappears" from our radar because we assume it is assigned and being worked.
I am looking to place a "timer" of sorts on the records where if the action drop down does not change after ...say an hour...it will automaticly switch back to the team designation so somone else can pick it up. Or better yet...if I could put a check box to indicate a record for them to keep and if THAT is not checked it would revert to the team designation after about an hour or even at the ned of the day would be acceptable.
Right now I am going in and checking each one and assigning them back out but that is terribly time consuming.
Is there any solution for this?
My Access skills are acceptable but by no means Pro level.
Even just telling me it's not possible will be appreciated.
Thank you.