Assign next item to next user

[mchetty]

MS Access help Assign next item to next user

Hi All:

I have a list of inventory (SR #s) in a excel under column A. And also there are 20 users using ms-access accessing by their user names. If a user completes one item, the next item from the excel should automatically goes to the next available user. After the item allocated to the particular user, under column B the user name should come and in column C there should be a comment saying "Done" Can i have a code for this in SQL or VBA. Please help.

Thank you,
Muki

 

[spikepl]

If you make an effort yourself then you are much more likely to get help. Otherwise pay someone to this for you.

 

[The_Doc_Man]

First, using Access 20 times to manipulate a common Excel spreadsheet is asking for trouble in the form of data corruption.

Second, the "pure" Access version of this code (using a split database with an Access Front-End / Back-End file design) would be far easier to write than any part that involved manipulating a spreadsheet. Besides, unless I totally misremember this, there are some restrictions on what you can do when your "table" is actually an external worksheet from Excel. You are constraining Access's strengths when you do this.

On this forum, you might indeed get some help, but if you ask us to design something that makes Access turn into a poor excuse for an Excel interface, we might tend to balk at that request.

May I respectfully suggest that you might get a better answer by briefly describing the problem that you are trying to solve WITHOUT references to the way you where going to solve it? Let us tell you what you should do architecturally without the statement that you need to use Excel for something in the middle of the mix.

If your problem is constrained in a particular way (because you have to use Excel data by the inherent nature of the problem), that is one thing. If you were just trying to use Excel because you didn't know any other way to do this, we might be able to suggest some reading on concepts that you would need to know to get this job done.