|
|
|
|
|
?slam'î Sûal Oyunu (May 27 2008 19:59 GMT) - mushaf-? ?erif denirpeygamberimize miraç'ta verilen hediyeler nelerdir? |
Microsoft Office Software
|
Form Control searches records in Table for a value (May 27 2008 19:59 GMT) - I have a trouble call ticket form and before the user can send it to close with a combo box selection I want the Trouble Ticket number searched in the Assigned Techs Table to make sure all Completed are marked "Yes" if not then it will exit the sub and inform (msgbox) the user that they cannot close until "assigned user name" (could be more than one) is completed. I've listed the two tables I have and the fields that are needed for this action just do not know where to begin on coding it. I'm assuming on the BeforeUpdate of my combobox that sends the ticket to close but how do I have it search the table for Completed value and return the message if it isn't complete? I have two Tables: T_TroubleCalls (TroubleID) T_AssignedUsers (AssignID, TroubleID, AssignedUserName,Completed) -- Message posted via AccessMonster. |
Propeller.com Do-It-Yourself Stories
|
Please, please, please, ... read this. (May 27 2008 19:59 GMT) - If you have never taken the time to read anything else I've sent you, I BEG YOU to read this E-Book ââ;¬" it may save your life... both personal, business, financial, and every other way you can possibly imagine! You may feel sick after reading itââ;¬Â¦ but make sure Channel: |
|