For simplicity, I have 10 items that I want 10 users to select. The users will select in a predefined priority sequence. (If you’re familiar with professional US sports, this would be similar to a draft.) Once a user selects the item, it is dropped from the available list, and then the next user selects an item. I would like to “lock out” the remaining users until the user making a selection, makes their selection and obviously disable users from making multiple selections. Everyone gets one turn and only one turn. I’d like to use a web browser for this process and have each user see a display of available items, make their selection, and so on until all items are selected.
I am familiar with MS Excess and Access and VBA.
Any ideas on the best approach or “tools” to use?
I am familiar with MS Excess and Access and VBA.
Any ideas on the best approach or “tools” to use?