William Benson
vbacreations at gmail.com
Fri Jun 3 22:42:29 CDT 2011
Wrong number of args because nz function requires an argument for whatever the replacement is for null Bill Benson Owner VBACreations, LLC On Jun 3, 2011 1:38 PM, "Tony Septav" <iggy at nanaimo.ark.com> wrote: > Hey Gustav > Thanks kindly > Tried your suggestion. > > Got the values to come out to1000>900 > > But the if statement doesn't fire, time to do some more testing. > In fooling around with this yesterday I even at one point got the error > message > "Wrong number of arguments or invalid property statement" > > Thanks again. > > Gustav Brock wrote: > >>Hi Tony >> >>Let Nz return a numeric: >> >>If Me!InvoiceAmount + Nz(Me!TotalInvoice, 0) > Nz(Me!Budget, 0) Then >> ..... display Yes/No message >>End If >> >>/gustav >> >> >> >> >>>>>iggy at nanaimo.ark.com 03-06-2011 18:23 >>> >>>>> >>>>> >>Hey All >>I have four controls on a form. >>JobCode - a combo box >>Budget -an unbound text box control source = >>format(me!JobCode.column(2),"#.###") >>TotalInvoices - an unbound text box control source = >>format(me!JobCode.column(4),"#.###.00") >>InvoiceAmount - a bound text box >>What I am doing (On BeforeUpdate) is letting the user know if the >>current invoice amount + the total invoice amount may exceed the budget. >>Just curious, can someone explain to me why this doesn't work >>me!InvoiceAmount=$200 >>me!TotalInvoice=$800 >>me!Budget=$900 >>If me!InvoiceAmount + nz(me!TotalInvoice)> nz(me!Budget) then >> ..... display Yes/No message >>endif >>When I check, the values come out to 200>900 >>But this does work >>If me!InvoiceAmount + val(nz(me!JobCode.column(4))> nz(me!Budget) then >> ..... display Yes/No message >>endif >>When I check, the values come out to1000>900 >> >> >> >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com