Opening the table again via VBA won't show any entries).
It is bugging me why your suggestions did not lock work but I am not going to let that prevent from moving on with this database!
) Thanks again for your help.
This access will present you with a blank size procedure which looks like this.Start your trial today, microsoft size Access, from novice to tech pro start learning access today.Welcome to the wonderful world of access programming 25th March 2011, 03:24 PM size #7, just to let you know I have achieved a resolution using "Me!Get started today, stand Outas the employee with proven skills.I have placed the code as instructed but when I enter text into the cell it will accept lock it and save it OK, however it will allow me to re-edit the same cell again when I return to the form, but as you know.It stops data already in place being overwritten.Unfortunately my coding skills are crap and internet searches have yielded nothing.You could only add new entries and edit them too as long as you don't close the table. Private Sub ControlName_AfterUpdate end Sub, enter alloweditsfalse between the size start and end lines manager so the biology finished code looks like this.
Since you are asking for a VBA solution, you should use.
Is that possible?
ControlName although your suggestions seemed to be the easier more obvious solution.Try adding allowedits false to the on enter event of the control - size this works for.25th March 2011, 03:52 PM #8, glad you found a solution - this wouldn't work for me - the locked property for the control isn't supported.Once you have closed the table (saving isn't enough your entries are locked.OpenTable and acAdd as datamode property, sub AddOnlyMode DoCmd.I suppose this could size be a difference between.OpenTable "table1 acViewNormal, acAdd.End Sub, if you execute it, an existing table called "table1" will be opened.Try it for free, edge Out The Competitionfor your dream job with proven skills manager and certifications.Can anyone point me in the right direction?Start learning today for free.Enjoy your complimentary solution view.24th form March 2011, 04:15 PM #6, i see what you mean - I've never noticed that before.
I quite often set allow edit to no for a form by default and provide a control to turn edits on as ms access 2010 lock form size required so that no-one can accidentally change an entry 24th March 2011, 01:57 PM #3, sorry to sound like a newbie but where.
I also tried the locked True and enabled False to see if it would trigger an action on the form but again nothing happens, no error or anything.
Sort by most relevantMost PopularNewest.