Search results

  1. V

    Zero value in query

    Hi, I have a query which calculate the total hours per job. These hours are split in working hours and downtime. But in case of only working hours I want the downtime hours filled with a "0" . I found a couple of threads on this topic but can't figure out how to use the code correctly. SQL...
  2. V

    Field visibility

    Hi All, I have a form on which a command button becomes visible if the value of a specific checkbox is true This works fine, but after I submit the form using the command button the form clears all the fields including the checkbox but keeps the command button visible. I have tried a few things...
  3. V

    Else criteria not working

    Hi All, I made a simple If criteria, but for some odd reason the Else part of the criteria is not working. I am probably overlooking something simple, but I cannot seem to find it. Hopefully some can help. If Me.Text18.Value >= Me.Text28 Then Me.Text20.Value = Me.Text18 Else Me.Text20.Value =...
Top Bottom