Recent content by ChrisC

Hello everyone, sorry for only just being able to get back to you now. Private Sub txtNewQty_AfterUpdate() Debug.Print "new qty: " & Nz(Me.txtNewQty, 0) & " Stock: " & Nz(Me.txtLocatStock, 0) If Me.txtNewQty < Me.txtLocatStock Then Me.txtTransactionInfo.Value = "You are deleting " &...

Hi MajP, I ran things with the following tests: txtLocatStock = 30 txtNewQty = 38 (which would add 8) and then I tried txtNewQty = 28 (which would deduct 2). then results of the debug are:

Hi MajP, thank you. Forgive my ignorance - how do I get that debug to run? simply add that line of code in after Private Sub txtNewQty_AfterUpdate() I guess?

I will try but sadly its a bit of a beast with lots of information already in it (we have been using it in the business I work for a while now, which is odd as to why it should stop working now). I will see what I can do though! Many thanks Chris

Hi DB guy, yes, even went through everything else line by line on the form that is completely unrelated to this part) and i cant see anything untoward.

Hi everyone, I hope you are all keeping safe out there! For an unknown (to me) reason, the following VBA code has stopped working as it should. Private Sub txtNewQty_AfterUpdate() If Me.txtNewQty < Me.txtLocatStock Then Me.txtTransactionInfo.Value = "You are deleting " & Me.txtLocatStock -...

Hi everyone - thanks for the suggestions and help :) CJ_London - that worked perfectly! I knew it would be something simple! thanks again Chris

ah i see, thank you - which heading would this come under instead? I have tried simply deleting it from the Group By section but of course that wont work on its own - i get the error:

Hello everyone, I have the following query: SELECT tblPurchaseOrders.PartNumber, Sum(tblPurchaseOrders.OrderedQty) AS SumOfOrderedQty, tblPurchaseOrders.OrderDate FROM tblPurchaseOrders GROUP BY tblPurchaseOrders.PartNumber, tblPurchaseOrders.OrderDate HAVING...

Thanks as always for the replies guys. In the end I went with your suggestion Minty of simply adding a field to my query and sorted by that. Perfect! thanks again!

Hello everyone! As the title says... is it possible to sort a report by its conditional formatting? I have formatted the field to be either RED, Orange or Green and I would like to be able to sort the report with Red on top, then Orange and finally green. Ability to then sort by other fields...

that appears to have sorted it! thanks very much to all for the help! im off for a lie down!

Thanks CJ - I see what you mean, I will have a try with that as well.

That works Gasman - thank you. The only thing now is that I get the following appear when the query is run; is there a way to avoid this?

Hi Arnelgp, still returns the same results im afraid! thank you