Search results

Hi Dave, I have removed the code in OnCurrent event and changed to Call Update CommissionDue, but i keep getting a Compile Error, expected end of statement. I have tried to research online but to no avail. I was going to upload a copy of my mdb but unfortunately it is split.

Hi Dave, Thanks for all your help so far, i apologise if this seems strange but i have no idea what you mean by creating a public function in the VB form. I have never done that before and dont no where to even start.

Thanks you so much Dave, it is finally working. I have one query though, if i select the checkbox it doesnt change to zero instantly, it will just stay with the figure in it and if i move out of the record into another and then go back it has changed, but not in front of your eyes so to speak.

Hi, i can still not get this to work and i am getting soooo frustrated. I have a tick box called CommissionPayable1 and a field called CommissionDue which has a calculated control field. All i want to happen is if i tick CommissionPayable1 then the CommissionDue will change to a zero. I cannot...

Hi thanks for coming back to me, i have tried what you have suggested but i receive the following msg "The expression you entered has a function containing the wrong number of arguements"

Hi Everyone, I made some changes to my db and now my when i select my tickbox the value is not changing to zero as it was before, i have tried the following in the control source =IIF(CommissionPayable1 = -1, [=Nz([GrossOperatingProfit],0/36*5,0) can anybody advise where i may be going wrong?

Sorry i do not understand what you mean?

Yes it is on a backup with dummy data inside. The GrossOperatingProfit Formula is =Nz([Amount],0)+Nz([DepositAmount],0)-Nz([Total],0)

I have done as you advised, however, my gross operating profit field appears to be bringing up a 0 value, would this be because that field is also has a calculated contol source?

SELECT Commission.TotalKitCost, Commission.ContactID, Commission.EngineeringCost, Commission.OtherCharges, Commission.Specify, Commission.Settlements, Commission.Specify1, Commission.GrossOperatingProfit, Commission.SalesRep, Commission.TelesalesRep, Commission.NetFigure...

No im only on number 2, i have been reading about queries, still not quite sure about which fields i need to include or how to get it to halve the value,

Hi, I am not sure if i am reading this correctly or understanding, i am not sure how to assign a query to a text box.

I will give it a go, this may send strange to you but i have never done a query before, wish me luck. Thank you for your help.

I am sorry but i am getting really confused over this and i am trying to research online but to no avail. In my first post i mentioned i have a calculated control of =Nz([GrossOperatingProfit],0)/2. I have seen that i failed to mention some further information which i apologise for if this is...

I could do that, i know how to get it to total the fields but wouldnt have a clue how to make it turn red if it didnt add up to the overall percentage value.

I have attached a screen shot of my form hopefully you can see now what i am hoping to get.

I removed the calculation from the control source.

Sorry maybe i wasnt clear there, the calculation in post #7 is the calculation that i placed in the after update event of the GrossOperatingProfits field.

Hi all, me again. I have a field called OverallPercentage and also Percentage, in overall percentage a value should be entered for example 10. The percentage field is set to continuous form and data is inputed into it. I am looking for an error message to appear if the values entered into the...

Hi John, That has worked perfectly but as there may be more than one record that is due to end in less that sixty days i was hoping it would alert on opening the db. Also is there a way i can assign it to a customerI.D so i can see the name of the customer on the alert?