Search results

  1. N

    How to hightlight fields that are null in a form

    Hey guys, Another question. When I click the save button on a form, before it saves the data, is there a way to check null fields, and highlight them? Thanks Nick
  2. N

    How to display blank fields in a form

    Hey guys, I was wondering if there is a way to display blank fields in all the text boxes until a customer has been selected from the combo box? At the moment, when you open the form it just defaults to the first customer. Thanks, Nick
  3. N

    How to add currency and round 2 decemial place in a button

    Hi guys, I've got a Save button that once clicked displays the Order total. I'm just not sure how to add the currency (dollars), and round to two decimal places. If it was a text box there is an option in the access interface, since it's a button i presume it needs to go into the code. In the...
  4. N

    Need help with a simple macro

    Hi there, I'm trying to sort out a macro so if the quantity supplied > quantity ordered, it gives an error, and won't update the quantity supplied field on a sub form with the higher number. If the quantity supplied < quantity ordered, i want it to minus the quantity supplied from the stock...
  5. N

    Cant get sum to work on a form

    Hey guys, So I've got a very basic problem, but i can't understand for the life of me how to solve it. 1. I have a main form 2. I have a sub form. In the sub form it contains the Unit price, and quantity supplied. I added a text box into the sub form which is the product total. The product...
Top Bottom