I have and it works like it should, nicely done!
Will do, next time I visit London Ill give you a buzz.
In the meantime I'm planning to start to learn SQL since I will be using it more often.
Thank you again, you've been great!
Hey, sorry for the delay, weekend is reserved for my family (wife, kid and a dog :))
Yep that did the trick!
I solved the problem with the date formatting that was containing "days" since it has more impact in presenting the time to the manager represented in hh:mm:ss
I just changed...
OK now I got enough data to define the problem.
When the journey starts (EN_AUTO changes status to 1) the db logs the change time into AUTO_ELV table and this is ok.
But when the journey stops the db also logs the change time into the table but overwrites all stopped times in frmJourney with the...
I've actually got it to work yesterday like 2 hours after our last chat, I succeeded in changing all the table names and field names in tables, queries and VBA, add an AUTOEXEC macro to run the frmMain at startup, removed the buttons "For testing purposes only" and ran it on the server for...
That was it, they were "Numbers" I changed it to text and no problems occurred. Sorry my bad! 🤦♂️
I'll play with it a couple of days and try to change all the names that came with the system update and get back when I succeed (or fail miserably).
Yeah it's pretty late here also but this week...
I've used the db you uploaded after relinking the ETAT_VEHI table from my downloads folder.
I have followed your steps, compiler did not retrieve any errors
Class module Form_ETAT_VEHI was missing Option Explicit so I've added it, but unfortunately an error pops up
I've tried to delete...
Duuuude, this looks great.
But unfortunately I get an error when opening frmMain "Undefined function "Duration" in expression" so the timer isn't firing. I'm using Office 2010 at work so maybe the expression is different.
It would also be great if I had a reset button or maybe even better if...
One more thing I was thinking about, the logic is set in the way that it inserts a new row on status change only when DATE_MODIF <> Now() if I understand it correctly. But it is a possibillity that veichle changes it's status in the same moment when the form's timer is set to requery, what...
I was planning on changing it later, now I've set it on 10 seconds just until I get it to work
This is great, and it works like a charm, however the immediate function does not work.
I was thinking maybe it would be better if I have 2 separate tables, ETAT_VEHI_OFF for when the vehicle status...
Swing.....and a miss
Got any ideas?
I'm sending ETAT_VEHI.zip with two files, ETAT_VEHI.accdb that simulates SQL server database and Zastoji offline iz ETAT_VEHI.accdb that was created following your steps
Note that I'm using date format dd.mm.yyyy hh:mm:ss, I've tried to change that but still...
Hahaha rookie mistake 😂
No surprises there, you are correct!
I will try the code and get back to you with the results, if it works the dinner is on me if you ever visit Croatia.
Of course, a tweak here and there is expected (as any other code)
I am fully aware of this disadvantage but...