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...
OK thanks,
Think will look into the WebSocket route but a brief google has no info on how to do that in Access so will have to investigate.
Used web control before but not as a websocket.
Thanks again
Python is run from access using shell & is left running all day.
When a call comes it, it updates the access table with just that one caller ID at that time & subsequent calls.
So the table is up to date but the form is not updated & I would not normally manually refresh.
If someone is near the...
Bit premature, I was testing on changing the table manually within access. Thought I had also done via python but seems not. Python odbc objects as I guess coming across something a bit alien in the table. Will investigate further but does not seem to OK
Not as access issue of course...
Currently manually, that was next on my list.
Will be run from access & start the python program at start of day (not sure what process yet) & it will sit in the background, it picks up incoming phone call & updates the table.
phone is only going every few minutes at most, potentially 4 or 5...
Many thanks for such a fast response ,sounds ideal, will look into it.
Tiny bit cautious about using another external process, just in case in the future the web socket changed, not always in a position to revisited coding the DB.
I may be talking rubbish as I don't know about the web sockets...
Hi,
Is there anyway to get a form to refresh when a record is added to a table.
Basically I have a python program to get caller ID from incoming phone calls (Gave up trying with VBA Tapi) & it updates the db table via odbc.
Works great, table is updated but I have a form that just sits there &...
Hi,
use to use an OCX that would connect to Windows/phone & modems settings & then to the TAPI setup from my NEC phone system
Basically the ocx could list all those devices & connect.
I just use to get caller ID & log all those who phone in.
Seems to have just stopped working, I think MS is...
Hi,
Definitely OLD, originally, way back, had New & actually struggled to revert.
Pretty sure from that learn MS page I have all the Methods, it just does not seem to have email addr. but wonder if just under a name that is not obvious, have tried most now.
Will try some more as a bit of a...
Thanks for your reply,
Think I have enough now anyway,
From ..
https://learn.microsoft.com/en-us/office/vba/api/outlook.reportitem.body
.CreationTime is the only one of the above that works on the olReport.
I can get .body & so can search & get anything else I need, of all the Methods listed...
Hi,
moved over to 365 as my mail server, for sometime used Outlook to get the email but only ever had olMail object.
this was fine for
.SenderEmailAddress
.ReceivedTime
etc.
However rejected/undelivered/bounced email are under olReport
olReport so far I have only found .Subject
None of the...
Hi,
Same for me..
I know a really old thread but had this problem for years ,only a program I use once a year & just re-opening & closing jsut seems to work in the end but trouble is it waste the labels I am printing on, not just normal paper. This time I went hunting for a solution
I have a...
Many thanks, this was actually so simple now you mention it, I was over complicating (as usual)
thanks again, implemented as above & works so well & could not have been easier.
Many thanks,
A good idea & guess can make very fail safe, just not too keen on having a separate file, no reason I guess but think perhaps table as source is the most natural. I was hoping an integral way to adjust the value list & store more easily than having a number of new tables with just...