Recent content by cheekybuddha

I haven't read this whole thread, so forgive me if this is irrelevant or already covered. If you need the hWnd of an Access control there is a method here on The Access Web: https://theaccessweb.com/api/api0027.htm

Is that something to do with the new query editor? Just a guess because of the form name.

Do you really need to do the loop to get the line number? What happens if you try: Function GetLineNumber(F As Form, KeyName As String, KeyValue) ' ... ' Loop backward, counting the lines. ' Do Until RS.BOF ' CountLines = CountLines + 1 ' RS.MovePrevious ' Loop...

(y) OK, but network latency may be worse! Just make sure to test as much as possible - especially with multiple users.

22 year necro - good work! :rolleyes:

Is this with a local dev server (or same LAN)? Make sure you test over WAN if you are using Azure for a more realistic sense of how long it takes. (y)

Both!

-- ... Totals AS ( SELECT ml.GENERATOR_ID, SUM(ISNULL(ml.QUANTITY_HAZ_KG, 0)) AS decTotalKg, -- ... Do you need the ISNULL() here or is it another extra unnecessary function call? I *think* SUM(ml.QUANTITY_HAZ_KG) AS decTotalKg should yield the same result.

Possible micro-optimisation: What version of SQLServer are you using? If 2017 or later you can use TRIM() instead of LTRIM(RTRIM())

If you go to Explorer options, and then View tab, you can uncheck 'Hide protected operating system files (Recommended)'. That might reveal your files.

Pretty grim to have to split and loop on every item! If you have 100 items and no repeats then you're close to 1000 iterations :oops:

Your description gives the feeling that you have a flaw in your tables design. If all products are available to all warehouses then you should have a single products table and a separate table for warehouses, and then a junction table for WarehouseProducts. Then, when you get a new product you...

You're welcome! (y) (I'm guessing that you took the above 'Returns' code from here and hand-edited it to resemble what is output by the function because you still have double quotes around (New) !)

Just in case it isn't obvious from the code, the trick is to add the delimiter you use to separate your values in the string before and after the value you seek. That way you avoid matching on partials. However, you also have to avoid the gotcha where the string being searched does not have a...

You could equally have removed the extra ( before .Column ! (Apologies, I didn't test 😁 ) Glad it works for you