Search results

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"...

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

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.

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 =...

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...

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...

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...

: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...

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...

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...

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...

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

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

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

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...

I have a form with a number of "cascading" comboboxes, each with simple Table/Query RowSources. When the user selects an option from the dropdown of the first combobox, the second combobox is requeried and revealed, with options relevant to the first selection. And so on down the list; each...

I'm trying to build a query that will insert new records into a table, which is effectively two columns of ID's (essentially foreign keys to/from two other tables) where the combination doesn't already exist. Basically, I have a source file/table, to which I join on respective fields to...

I am old fashioned and also really uncool so that argument resonates with me... 🤓 Thanks everyone for your respective inputs!

I mean, I can - similarly I can just use CLng() to force the type - I do have a "solution" for the problem, I just don't understand why the problem exists in the first place (more importantly, whether I need to be concerned about other very similar queries that work just fine without re-casting)...

I have a query which takes a parameter (a User ID) and then appends a record to a table using that parameter, along with a couple of other fields from a staging table, assuming a similar record doesn't already exist (tested using an outer join). Not a complicated query and I have dozens of...