Search results

  1. B

    change data using public sub

    Sorry my poor English, but i dont understand. Your first mesasage, you said.. If chkBlue = -1 Then Blue = 1 Red = 0 End If What is blue and red? How do you set your table fields?
  2. B

    change data using public sub

    Hi again ;) Call CheckUncheck(chkBlue, FormControl_Blue_Name, FormControl_Red_Name) same as chkblue
  3. B

    change data using public sub

    Hi; Public Function CheckUncheck(Chk1 As Control, CheckVar As Control, UncheckVar As Control) If Chk1 = -1 Then CheckVar = 1 UncheckVar = 0 End If End Function
  4. B

    IFF Statment

    Hi; Do I understand correctly I do not know ?? Try it; Sum(nz([Score 1],0)+nz([Score 3],0)) or maybe u want it?? iif(isnull(score3),score1,score1+score3)
  5. B

    Adding controls

    Unfortunately with the Ms Access can not be added object in the runtime :(
  6. B

    Track changes using query

    Hi; If I understood your question correctly, try it; Select a.board, a.PartNo, a.TimeStamp, a.Description,a.Status From Your_Table_name AS a Where exist (select last(board) from Your_Table_name where board=a.board...
Top Bottom