Search results

To be clear you have a single text field per row with values separated by a single space? Your example data seems too simplistic. What identifies the pair? Customer? Order? Item? A combination of 2 or more? Can you only have one row?

What happens if a file is deleted? why not use a datetime value suffix? Myfile_250615_112435

You can still use a dlookup - just modify the where parameter along the lines of my example - having first added and populated your min/max char fields. You mentioned 3 chars but your example was for two

If you are currently basing on the first character what is stopping you basing on the first two characters? If this is an exception just for those companies start with A that would be AA-AM then AN-AZ. Companies starting with B would be BA-BZ, etc You would need a range comparison e.g. Where...

Don’t think you need quotes around the 2nd parameter

This thread is about printers - suspect you are responding to a different thread

Agreed - but my point is we don’t know how the OP has determined these values, so they could have introduced a null value Either way, it appears the problem has been resolved

The ‘Boolean’ value in the query may produce a null - all depends how it is determined. For example Istrue: iif(a=b, true) Will return a null if false

Are all your update queries mutually exclusive? I.e. a specific record can only appear in one update and cannot be updated by a later update? And have you opened the query to verify all your calculated booleans are populated and correct- logic being if the sql is valid then the issue will be...

Perhaps rs1.FindFirst "family like '" & Left(str, nLen) & "*'"

Technically it is the visible property- a control with visible set to yes but hidden behind another control can still receive the focus, as can a control with height and width set to 0

you could select both controls and conditional format using the expression is [control B]= "xxxx" rather than field value is = 'xxxx' in control B. Then both controls have identical CF

how about controlA.BackColor=controlB.BackColor where to place it? - perhaps form open, load or current event, perhaps when some control get the focus

I should have updated - I found a way to make pdfToText work significantly faster (<0.5 seconds). I originally had it set up to work in memory to return stdOut. But found if I use it to write to a temporary text file, then open the text file to get the text it is much faster. I had wrongly...

it doesn't - it's just about using the right tool for the job.

If you want today’s date why not use the date function rather than now (which also includes the time)

I create a querydef property to store formatted sql with comments - my sql editor is a richtext control and keywords are coloured depending on type of keyword. However probably obsolete now with the coming of Monaco

My point is any method of valuation comes into it that is appropriate for the business, not just FIFO. It is a decision a company makes as they would for any other aspect of their finance such as depreciation. Anyway the OP is not coming back and I’m trying to clear my desk before going away...

agreed - but if you are buying widgets for £1 (cost) and are able to sell them for £2, that is the net realisable value. If a competitor starts selling them for £1.50 and you drop the price to compete, the cost is still £1. Only time net realisable value drops below cost is when the widget...

it all depends on the nature of the business - FIFO is OK for retailers and wholesalers where typically you have large quantities coming in and small quantities going out where all they are basically doing is providing shelf space. But not suitable for businesses who have to value work in...