Recent content by Leopard011

Dear Arnelgp, Thank you so much, worked fine :)

Dear Paul, Thanks for your help, really appreciated. As for the link, I'm a little bit confused, how could I use it as an expression not using VBA?

They are referring to fields in subreport.

Hello! I have a textbox in report which should sum 3 fields, The first error occurred because sometimes one of the fields returns NULL, so I've used Nz function, the problem is it's now returning #size error :banghead: The expression is as follows...

Dear Wayne; I've put the code in after update event because it's the field where I write the required material amount and before i go to the record button which trigger the save event to be like this: 1- the required materials in >> M_Q 2- the available materials in >> M_Available 3- Button...

By the way, Is there any way to hide the access message which appears after each append action ? I mean to make access add silently without all these messages ?

Dear All, I have a simple equation to check if the materials in warehouse are sufficient for use as required or not I wrote a label to alert the user if there is no sufficient amount for use So, if the required material has sufficient amount , I need the alert to be invisible The problem is...

Thanks sooooooo much

Dear All, I've a problem with my Append Query, each time I run it, it keeps duplicating entries, the confirmation message tells me that I'm going to add 1 row, this is OK the second time to run >> 2 rows 3rd one >> 4 rows , 16 , 32 and so on and each time i run it it keeps...