Search results

Any idea if I need to use SQL in order to store et get the previous scan time ?

Thanks CraigDolphin, your help is much appreciated ! I tried using the code after having modified it a bit. There seems to be some sort of mistake somewhere. I built a query using datediff and it works. The only part that does not seem to work is the vba code to get the previous scan time...

Thanks CraigDolphin, I'm finally moving forward! I have previous entries already and now Hours_finish always gives me a result of: "00:00:00" Hours still gives me the current time in this format: "2012-05-29 13:17:27" as an example. Any idea why Hours_finish always give the same answer ?

Here is a part of my actual code. "Product" is the product number when an item is scanned. "Hours" is the current time when an item is scanned. I want "Hours_finish" to be the time of the previous scan. If Product <> 0 Then Hours = Now() End If If Product <> 0 Then Hours_finish =...

Hours field in the data table is set to Time To store the hours in the hours field, I simply use: " Hours = Now() " I'm running the DMax code after the latest scan is entered. Thanks!

Any idea, even short ones ? thanks !

So far, when I scan a product, it records the current time with a Now function. What I need is to know how much time elapsed since my last scan by doing a Datediff with the previous time recorded. My problem is that I can't manage to get the previous scan time. I thought of two ways to do this...