Recent content by neilCarey

  1. N

    Clear all boxes in form

    Maybe the best thing to do is write VBA for all boxes to work out cost and VAT, Plus VAT and total amount with a button that clears all boxes if a user needs to. At the moment nothing is working. Kind regards.
  2. N

    Clear all boxes in form

    I'm trying to 'Call ClearAll' when I click the clear button and nothing is working.
  3. N

    Clear all boxes in form

    Option Compare Database Option Explicit Public Function ClearAll (frm As Form) Dim ctl As Control For Each ctl In frm.Controls Select Case ctl.ControlType Case acTextBox ctl.Value = "" Case acOptionGroup, acComboBox, acListBox, acCheckBox ctl.Value = Null...
  4. N

    Clear all boxes in form

    OK what VBA would you suggest.
  5. N

    Clear all boxes in form

    And what VBA would you suggest?
  6. N

    Clear all boxes in form

  7. N

    Clear all boxes in form

    I've tried that and it will clear a box that has txtCost for example, but because it has an expression in it, it will not clear.
  8. N

    Clear all boxes in form

    Hi Thanks for getting back so soon. I need the control source there as it works out mathematical costs. When a user goes into the form and works out costings they may need to reset the form and clear it to re put the the new cost in. if that makes sense.
  9. N

    Clear all boxes in form

    Hi guy's I have a form called 'costings' which works out cost - VAT - PLUS VAT ect.. I have the problem where in for example -Property Sheet - Data - Control Source =[CRMCost]*0.2 Because it doesn't have a name 'txtCost' I can not write VBA to clear these boxes...
See more
Back
Top Bottom