Search results

  1. L

    Overide calculated control field

    Can anyone help at all,,, please.
  2. L

    Pop Up Box 2

    Hi all, i am trying to get the above code to work. I have placed it in the on load event of my form and put in a date of 17/12/2010 for testing purposes. However i cannot for the life of me get it to work.
  3. L

    Overide calculated control field

    Hi Dave, I am trying missinglinq advise.
  4. L

    Overide calculated control field

    I am using =Nz([GrossOperatingProfit],0)/2 in the control source.
  5. L

    Overide calculated control field

    Thanks for helping, i have tried what you suggested, i have placed the calculation in my gross operating profit after update and removed the calculation from the control source but the figure just shows zero, i cannot get it to work out the value??
  6. L

    Overide calculated control field

    Sorry Dave, sometimes the amount may be slightly different but only on a few occasions so i was hoping that maybe i could edit it.
  7. L

    Overide calculated control field

    I have a calculated field, with a control source of =Nz([GrossOperatingProfit],0)/2 i am hoping that if i have a yes/no tick box and i select yes that i will be able to manually change the figure in the calculated field. Is there a way i could do this?
  8. L

    0 Calculated Field if tick box selected

    Hi everyone i worked it out in the end so thankyou for all your help. Maybe you could help with another query i have? I have another calculated field, with a control source of =Nz([GrossOperatingProfit],0)/2 i am now hoping that if i have a yes/no tick box and i select yes that i will be able to...
  9. L

    0 Calculated Field if tick box selected

    Hi, The calculation i have in my field is =Nz([GrossOperatingProfit],0)/36*5 Many thanks for your help
  10. L

    0 Calculated Field if tick box selected

    I have a field that has a formula attached that will work out commission based on other fields, the total is then displayed in that box. On occasions that figure will not be due so i would like to have a box of tick box that i could select which will set the figure to 0. As there is a...
  11. L

    0 Calculated Field if tick box selected

    Hi everyone, I have a formula which works out commission based on various other fields. On occasions i wont want it to be worked out and will want it to be zero but on others i will require it to be worked out. If i place a tick box next to the commission field saying paid yes/no, if i...
  12. L

    Percentage Calculated field

    MStef I have done it, thank you so much for all your help and patience.
  13. L

    Percentage Calculated field

    Hi MStef I have opened your Form2 and that is exactly what i want however i cannot work out how you have achieved this. I would prefer not to use a Query.
  14. L

    Percentage Calculated field

    Hello, it was set to continuous but all the other fields do not duplicate across them all but that one field does?
  15. L

    Percentage Calculated field

    Thanks for all your help everyone i now have it working with one slight problem. My form is a tabular so the end value is duplicating on all records which i dont want???
  16. L

    Percentage Calculated field

    Hi John, I have tried what you advised in post number 3 but my "AmountDue" field displays #Name? and doesnt work it out, i am placing the code in the control source of the AmountDue field.
  17. L

    Percentage Calculated field

    Hi All, I still cannot get this to work :-( if i explain by example: I have on my form 3 fields all next to each other, one is called "call spend" then "percentage" then "amount due" If i enter £2850 in to call spend and 10% in to percentage i want it to work out the 10% of £2850 which will...
  18. L

    Percentage Calculated field

    The problem is i want it to work out the percentage back value and place in the total box but am unsure as to the formula as the percentage will always differ.
  19. L

    Percentage Calculated field

    Hi Everyone, I am adding a new form to my database which will have a field called "percentage back" there will also be a field called "monthly costs" once a figure has been entered into the field "monthly costs" i would like it to work out the percentage figure and put that into a "total...
  20. L

    Split Database Replica

    Hi all, Please help all you can. I already have a split database, the back end on a server and front end on two computers. I want to copy the database so i can amend it for our other company. I have copied the front end and back end to a new location so im guessing i need to relink, then make...
Back
Top Bottom