Recent content by AOB

  1. AOB

    UPDATE with LEFT-JOIN (conditional update query)

    So, I mean... This works : PARAMETERS SpecifiedRecordID Long; UPDATE tblRecords R SET R.LockID = SWITCH(Nz(DLookup("Outstanding","[qryOutstanding]","[RecordID] = " & SpecifiedRecordID),0)>0,-1,TRUE,0) WHERE R.RecordID = SpecifiedRecordID; But it seems awfully clunky compared to a "straight"...
  2. AOB

    UPDATE with LEFT-JOIN (conditional update query)

    I could but I figured a simple JOIN on an existing (fast) query would be a lot easier? Evidently not?
  3. AOB

    UPDATE with LEFT-JOIN (conditional update query)

    I don't update the Outstanding field. I update a field specific to the tblRecords table based on the number of outstanding items against it elsewhere. qryOutstanding is just an aggregate SELECT query that gives me a calculation of all outstanding items per record.
  4. AOB

    UPDATE with LEFT-JOIN (conditional update query)

    I am trying to UPDATE a table based on the result/value for the corresponding record in a separate query. This is the basic syntax of the query : PARAMETERS SpecifiedRecordID Long; UPDATE tblRecords R LEFT JOIN qryOutstanding AS Q ON R.RecordID = Q.RecordID SET R.LockID =...
  5. AOB

    Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?

    Thanks so much @MajP I had already taken your first sample and added code to allow the ChooseColor API version to be used where any of the palette selections were unsuitable. I also, like you did, recreated the palette from the Excel context menus so that they are consistent. (I actually built...
  6. AOB

    Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?

    By "runtime" I just mean that I want some interface by which a user can specify a colour and pass that back to the code. The dialogs mentioned by @isladogs in post #7 would be perfect - as they are consistent with the kind of colour pickers users would see in native Excel and so have an air of...
  7. AOB

    Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?

    Either of these would be absolutely perfect; the issue I have is how do I "produce" either of these pickers within my own interface (at run-time, not design time) such that a user could select a colour from it and my code would take the integer interpretation of it (be it RGB, Hex, whatever) Is...
  8. AOB

    Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?

    :ROFLMAO: Sorry @Gasman - that genuinely wasn't meant as a slur on anybody that uses those colours 😳 I should have phrased it more delicately... "None of my users would select any of those base colours as they are a finicky bunch who think that the Excel palette is more appropriate for their...
  9. AOB

    Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?

    Honestly, it's purely for aesthetic / convenience. The native Windows ChooseColorA API is perfect in that it provides a ready-made visual interface to specify a colour and return it as a simple long integer, to apply where needed elsewhere. My only issue with the ChooseColor option is that the...
  10. AOB

    Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?

    Does anybody know if, when calling the Windows Colour Dialog (to provide an option for a user to select a colour for something) : Open the Windows Color Dialog from VBA ...is it possible to define, set or change, the Basic Colours that are loaded into that dialog (as opposed to the Custom...
  11. AOB

    Solved Detect whether a combobox selection has actually changed or just reselected?

    Thanks @isladogs - I totally get you and agree - but users are unlikely to press the Esc key to "cancel" the dropdown, especially when there's only a handful of options. Users have already clicked on the dropdown, realised that they had made the correct selection all along, and simply re-select...
  12. AOB

    Solved Detect whether a combobox selection has actually changed or just reselected?

    Nice! I like this - working nicely for me and easy to keep track of. Thanks @MajP !
  13. AOB

    Solved Detect whether a combobox selection has actually changed or just reselected?

    Seems a bit clunky when all I want to do is flag that the selection has simply changed?
  14. AOB

    Solved Detect whether a combobox selection has actually changed or just reselected?

    Comboboxes are not bound, no (corrected my original post, sorry!) They are populated by queries via RowSource but not bound to anything.
  15. AOB

    Solved Detect whether a combobox selection has actually changed or just reselected?

    Thanks @isladogs but your app has the same problem I do - for example, if I select an Area from the first dropdown, then a District from the (cascaded) second, then a Sector from the (cascaded) third, Zone from the (cascaded) fourth etc. And then at that point, I return to have another look at...
Back
Top Bottom