Recent content by bignose2

Very many thanks, Sorry did not do too much research just now, just go back & need to fix asap. last week I had just flown out of the country for my daughters wedding, checked & double checked all working, back PC's etc etc. before going so could not believe this as rarely go away. following...

After more debug F8 finially found the trigger, seemed not to flag up before but might have been me! set regex =createobject(vbscript.regex) fine on the other PCs so to investigate. Is there something I can perhasp re-install or best to really try to find the reason. been fine for years

Hi, one of my front ends has just started getting this error. when I click on a button to open a form no error or debug just as below, Abort just freezes have to do a full close X, Ignore just keeps flashing the same message. Retry sometime continues on normally but no info. this is in a...

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

That is ideal, thanks very much. working well, just have to as you say work on the timing for the update but great that I don't have to use timer.

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