distribute records to different users...

[Nick123]

Hi!

I have a table that contains 15 fields and the same table have nearly 1000 records. Now the process goes like that every time I am getting an Excel file that I have to imported in MS Access table (the table which i referred on top).

However only 4 fields needs to be populated(appended) from excel and rest 11 have to be entered by the users. Now that database and table resides on shared drive.

My requirement is :

Say I have appended 100 records into access table from excel only 4 fields filled. Now in order to fill the rest eleven fields I need to distribute the work in such a fashion that every user will get 20% of records. Means user1 will get record number 1001 - 1020, similarly user2 gets 1021 - 1040 and so on so forth.

I need a VBA code for the same. Or any other suggestion for doing the above work is highly appreciated. However the process flow will remain same that I have to import 4 fields from excel and so on... so no changes possible in the process...

Thanks in Advance.

Regards,
Nick

 

[The_Doc_Man]

OK, Nick, a question.

When you distribute this data set for someone else to work on it, is there any logical reason to assign records to any one person in any one order?

What I am thinking is that if you add a field as the "selector" you can set it to a random value in several ways. Then let each person have a different query to select records based on one of the possible random values and the fact that the record needs populating.

So if your split is 20% per person, that is 1 / 20% = 5 so you pick random numbers from 1-5 and put them on your records. Or you COUNT the records as you go and store the record number modulo 5. Then the five folks each pick based on that selector and there you go, an even distribution.

 

[Nick123]

Thanks for your reply

Dear Doc man,

Thanks for your reply ...

Scenario is that I have access database which resides on shared drive now there are certain set of records which needs to be entered by different users at same time. If you would like to enter any field then i would like you to know that the 15th field of table contains the username. So if you wish you can use that field name to allocate the name of user to that field first say "User1" and then allocate different records to different users basis username.. (this is just a suggestion if you have any other idea then most welcome..)

However once I got the result set then I have to distribute the data among users. SO i need some logic (code) so that a fixed percentage say 20 gts divided among different users logged in. There is a separate table called user which contains the username and password information of users.

Pls help.

Best Regards,
Nick

 

[Nick123]

Pls help....