Help Please

[raji]

Hi, I am relatively new to access and we have a current database in use. The problem is that people accendently change the dt in a field so I have been asked to creat a button which will lock it and another button which will unlock it so that the user can enter data into this field. I can go to form, design, creat a button but each button has a specific function which I have to select to it to perform that function. I cannot find one which say lock field and unlock field. Please please I am not stupid but will be grateful to anyone who can give me very basic steps on how to achieve this. Many thanks, Rajni

 

[accessfever]

If the user has access to both buttons, then why not just create ONE button with a message if the user really wants to make the change? If the answer is yes, then allow the user to make change. If the answer is no, then direct the user away from the field.

 

[ghudson]

I prefer to trap for changes in the before update event of the text box in question and pop a message box and ask the user if they are sure they want to change the date [give them a before and after value] and give them the buttons to click yes or no if they want to keep the change.

Or, you could lock the text box and make the user click a date picker to set the date for the text box in question.

 

[raji]

Thanks for your replies but you see I am not very proficent with access. All I can do is go into design, then creat a button drag it and bring it into the form but then it asks me what do I want the button to do giving me a choice of pre-fixed functions such as open database, close, find etc. I need to select a pre-aasigned function. What do I need to do say after I have dragged a button into the form view then what do I do. How can I make it to lock this record and what do I need to instruct it to do in order for it to ' unlock' the record when it is clicked. This way the user has to be certain if he/she wants to unlock the record to make the changes. I am not sure how to do this. Please help me with this I am getting so frustrated by being thrown into deep end. Raji