Search results

Dear CJ_London, Thanks a lot for right direction, i have tried with your seggestion and end up with the below statement and fixed my issues. Got working like charms CurrentDb.Execute ("UPDATE tblWA INNER JOIN tblLOTO ON tblWA.WAPrefix = tblLOTO.WAAndPrefix SET tblWA.PermitStatus =...

Dear CJ_London/ All, Would you mind for helping me once again since i have one bit of issue. I am trying to update another table and have know idea with Inner Join As above i want to update the WA Status As "On Hold" with those LOTO/s are associated with the WA. Since WA numbers are stored in...

Dear CJ_London, The above issue is fixed now with Me.Dirty = false after playing while Thanks for your help Regards, Tamang

Dear CJ_London, Appreciated a lot for help and got working with your code. But i got Write conflict message on my screen. Is there anything we can write to above that message. I did some modification docmd.requery but still the message keep showing up on my screen Thanks & regards, Tamang

Dear Experts, I am here again seeking for help as usual I have some issues regarding updating in table How can achieve update sql that does my need I have table called tblLOTO and i want to update field where my cateria meets. I want to update all the filed where my LOTO # matches and...

Dear Smig / larkcovey There was no any error messages from the event however after 2 hours of hard work i got my result. This is how i achieved and did, may be not the best code writing but its working effectively. Here is code i used Private Sub PermitStatus_GotFocus()...

Dear Experts This is my first time ever in Forum and seeking of big help from all of you. I am very very new to VBA and I have been self-learning VBA from two month and have been assigned to new project “Work Authorization & Lock Out Tag Out” I have table called tblWA & tblLOTO Basically most of...