 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / April 2005record becomes read only after updating
hello all, this is what I am trying to do. I have an orders form that my employes use for entering new orders. I want the users to be able to enter the form without having to enter a password to enter a new record, but only if they wanted to edit a record... is this possible? if so can someone point me in the direction that I need to go? Thanks, Brook >hello all, > [quoted text clipped - 3 lines] >wanted to edit a record... is this possible? if so can someone point me in >the direction that I need to go? I'd suggest setting the form's Allow Additions property to True, and Allow Edits to False. Put a command button on the form to switch the AllowEdits property to True, with a password (I think you got the instructions for this in another thread); switch the AllowEdits back to False in the Form's AfterUpdate event. John W. Vinson[MVP] Thank you for the help... that is exactly what I was looking for... yes I did get the password option in the other thread... If I could ask one more quesiton of you... is it possible to have it set up so that I double click on any of the form fields it can ask me for a password for editing? Brook > >hello all, > > [quoted text clipped - 13 lines] > > John W. Vinson[MVP] John, One thing that I have noticed while getting this set up with your options you told me about.. is that if I close my form then go back in, I don't see any of the records from my table? I am able to add a new record, but can't see the other 50 records in my orders table? Any suggestions? Brook > >hello all, > > [quoted text clipped - 13 lines] > > John W. Vinson[MVP] >John, > > One thing that I have noticed while getting this set up with your options >you told me about.. is that if I close my form then go back in, I don't see >any of the records from my table? I am able to add a new record, but can't >see the other 50 records in my orders table? Sounds like you set the Data Entry property to True (instead of, or in addition to, the Allow Additions). John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.