Marcus H
03-06-2001, 01:24 AM
To change data on my field i would like the person to have to type in a password. EG if they wanted to change the cost price in the 'costprice' field from £10 to £12 they would type in £12 and then have to type the password for it to go through. Is there any way of implementing this? Any tips would be smashing. Cheers.
llkhoutx
03-06-2001, 07:59 AM
Use VBA code: when OnEnter fires, save the original value, then when AfterUpdate fires to open a Password Window prompting the user for a Password. If the Password isn't entered after three tries restore the data to its original value. You could have one password for all or a password for each user.
Marcus H
03-06-2001, 11:27 AM
How do i set up a password window to implement this......how do i assign lots of passwords so each user can have there own?? Thanks for any help again!