Require code for Random Number generator

[AshikHusein]

I would like to know how you could generate a random number say between 1 to 1000.

I have this multi user data base which has been split and it is financially dangerous that two user can view the same client records.

I have other checks in place through VBA but when a user activates the next button, it must go through a FOR loop from one to the generated random number so every user has a different delay time when they are moving on to the recordset with the .movenext command.

Would appreciate urgent help in this matter. Thanks.

 

[Friday]

Check this thread out. I believe you will find the answer here.


autonumber