Automatically Refresh a form when table data changes externally, table macro perhaps?

[amorosik]

Hi,
It is business class'ish. NEC SL1100 but may be changing sooner rather than later so probably would not look to that.

Websocket does seem the way to go (worst case slower'ish timer)
I should be able to figure all the regular VBA programming, refresh, requery etc. its is more the VBA listening side of a webbrowser, websocket which is new to me & found very little on but guessing will not be complicated & once I have time to look sure so won't be a problem.

Python has lots of info so sure will get the server & sending sorted on that side.

It may be I have to move to a cloud based IP system soon anyway so all this may be fairly irrelevant, I was wondering how that will all work as they must have systems that use the equivalent TAPI to match calls to a database but the company trying to get me to move to IP were not sure how that would work so holding of until UK BT force the issue or the NEC breaks down & actually the NEC can still work on an IP system but being old think may be time to move to cloud then anyway. I digress!!

In reality it is not necessary to update a grid with the current recordset
In fact it is harmful because the operator could be in the middle of a modification
What I would do is simply 'display' the incoming call or in any case the change of state in the telephone pbx
Then it will be the operator who will do something if he deems it appropriate, for example he will click on the command button that has been enabled and signals an incoming call or other things of this type