Search results

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

Use task manager to compare memory and cpu usage

I would say FIFO is a method, it is not the only method

Have you looked at the links provide by JDraw in post #3? Is there any reason why are you using FIFO? it is fraught with problems and often shows no real benefit in these days of relatively low inflation. Have you considered using standard costing/variance analysis or average costing instead...

You also need to consider stock changes such as damaged items - can you identify which price to assign to stock writeoffs ?

It is perfectly doable by modifying the rownumber function and ensuring the query is sorted by 'group'. But without data and a clearer understanding of the requirement, not prepared to spend time providing further example.

So have a number of small text boxes or images which display a X which a user can drag and drop to the required position over the image. Or perhaps display a number instead so the use can relate to some numbered text. Depends how much detail is required as to whether it is a fixed list...

What sort of text are you entering? An X at each damage point? Or words such as dent or scratches? What about tyre or wheel damage?

Did you try the app I uploaded?

Without understanding the actual requirement you could investigate using a web control and generate html code to display the image and allow you to type on it. Don’t understand: Is this one textbox covering the entire image? Or multiple smaller textboxes? Once you have your typed over image -...

Hope they don’t nick your computer 😀 Without seeing the relevant code and properties of the relevant controls, difficult to suggest what the solution might be.