Search results

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!

I thank you from the bottom of my heart Sir, dinner invite in Croatia is still on!!!

Haha I'm slowly becoming your worst nightmare 👹 Sorry about that! Here is the latest version

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

Again same fault

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

Column A is the ID_VEHI and column G is AUTO

I am sending ETAT_VEHI table exported in .xlsx There are number of fields that are not relevant for this case, but the problem is that any change that happens in any of the field in the table updates DATE_MODIFIED field, and only relevant information for me is the time change of the AUTO field

Are you kidding me, you're turbo fast in comparison to other forums, I thank you for that!!! I have created a form from ETAT_VEHI table and set it to auto-refresh (Me.requery) every 1000ms, the table itself is rather small and does not contain a lot of data so the impact on the server is...

I'm not changing status by hand, status is being changed automatically when a vehicle sends signal that he is not in automatic mode (status "0"), and again when it is in automatic mode (status "1") Vehicle field is "ID_VEHI" and status field is "AUTO", SQL table name is "ETAT_VEHI"

Wow guys that was fast! Thank you for your responses. I was using analogy with the cars just as an example, I already have a table with the vehicle numbers and status that is changing automatically depending on real situation with the vehicles, it is a server based SQL database and cannot be...

Hello all! I need some help with the problem I'm facing. Let's just say for example I have a vehicle and when he is driving the status of the vehicle is "1" and when he is not driving status is "0". I need the timer to start as soon the status changes to "0" and pause when status changes back to...