Hi,

Is there a VBA code to enter the same data over and over for a range of dates.....For example if an employee wants to update his login and Logout time for a range of date from 12/01/2007 to 12/31/2007. The login and logout times are going to be the fields and the date is also a field....the code should allocate the same login and logout time to all the fields for the date range in question, in case there is variation there should be a seperate code to change the login and logout time....Also the 3rd part of this code should lock the user's ID for his own login and logout time and he should not be able to manipulate others records...I think creating seperate forms for all the users is not the right way...one form should have a button which will enable the user to update his records and he should not be able to manipulate the records of others....Is there a neat code for this....or can somebody help me with the programe for this kind of scenario......

I think the way to lock the users from manipuilating others data is by calling the logon Window from the code and then recognising the Employee ID. Also to add to it the employee should not have to repeat his ID, Address, Manager's Name these should automatically get picked from the code and should fill the table with which this code is connected....In short anything which is repetitive should be taken care by the code....