Search results

  1. S

    Need help in looping vba

    for more clear, I want to do a looping like sample attached. case 1 is ok case 2 is NG because Cid < MCav, user cannot update the Mid.
  2. S

    Need help in looping vba

    I'm also write this code. It's work for more than MCav. What I want if Cid is less than MCav, User not allow to update for new Mid. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.CMID > Forms![Navigation form]![NavigationSubform].[Form]![MCAV] - 1 Then MsgBox "MORE THAN MId...
  3. S

    Need help in looping vba

    Sorry ..I'm stuck in Recordsetclone.:mad: Need a help and attached the accdb.
  4. S

    Need help in looping vba

    Yap...is correct. Thank I will check with Mr google.:)
  5. S

    Need help in looping vba

    Noted and Thanks. But the looping still ng
  6. S

    Need help in looping vba

    Hi..I need a help on my looping: In the main form, I have textbox MID=M123456 and CAV=4 In sub form, a. I have CID and DateTime. b. I add MCID =Count(MID) I want to do a looping for CID <= CAV if >4,msgbox "More than CAV" then undo if <>4,msgbox "Less than CAV" then MID will lock...
Back
Top Bottom