Locking record question
I have a split form for entering test results. There can be a hundred results to enter - so many lines on the bottom datasheet portion and a larger top portion with a couple option controls, memo box and several fields. (So wouldn't work well in continuous form)
My user is having trouble keeping track of what line she is on when entering results and would like to be able to have a check box or something to "lock" each record when she is done entering the results. She would also like to have that line display in a different colour but from what I've been reading that isn't possible in datasheet view like in the split form. So, I'm hoping I can at least put in the locking function for one record at a time and still have the datasheet portion usable for the records that have not been locked yet. Any ideas?
My user is having trouble keeping track of what line she is on when entering results and would like to be able to have a check box or something to "lock" each record when she is done entering the results. She would also like to have that line display in a different colour but from what I've been reading that isn't possible in datasheet view like in the split form. So, I'm hoping I can at least put in the locking function for one record at a time and still have the datasheet portion usable for the records that have not been locked yet. Any ideas?
ASKER
It's an actual split form.
<< She would also like to have that line display in a different colour but from what I've been reading that isn't possible in datasheet view like in the split form. >>
That's correct. You can do it with a form in continous form view, but then you'll need to do extra work to make it navigate like a datasheet.
<<So, I'm hoping I can at least put in the locking function for one record at a time and still have the datasheet portion usable for the records that have not been locked yet. Any ideas?>>
Your going to have a tough time doing anything with a data sheet.
Before I offer anything, what version of Access are we working with?
Jim.
That's correct. You can do it with a form in continous form view, but then you'll need to do extra work to make it navigate like a datasheet.
<<So, I'm hoping I can at least put in the locking function for one record at a time and still have the datasheet portion usable for the records that have not been locked yet. Any ideas?>>
Your going to have a tough time doing anything with a data sheet.
Before I offer anything, what version of Access are we working with?
Jim.
I would try the following: once the record becomes dirty, engage before_update event that will cancel any update, until global variable allows it. Set the global variable by the "unlock" button.
ASKER
jdettman - I am using Access 2010.
vadimrapp1 - Are you saying once a record is typed into the user would have to click a lock button to save it? So then if the button wasn't clicked no changes would be saved? That could work, the big question is then can the user go back and unlock to make changes to the record and then lock again to save changes? And the bigger question, will that work with a split form? So the user could click on another line in the datasheet part, type into the record in the top form, click lock and then move on to the next record?
Thanks for having a look!
vadimrapp1 - Are you saying once a record is typed into the user would have to click a lock button to save it? So then if the button wasn't clicked no changes would be saved? That could work, the big question is then can the user go back and unlock to make changes to the record and then lock again to save changes? And the bigger question, will that work with a split form? So the user could click on another line in the datasheet part, type into the record in the top form, click lock and then move on to the next record?
Thanks for having a look!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm so sorry I've let this sit for so long. Going in too many directions. This isn't exactly what I was looking for but I can adapt it for my needs. Thanks so much!
The SPLIT form is a special type of form available in Access 2010 ... but you can also make your own "split" form by using two subform controls - so we need to know which you're using.