Search results

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, 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, I cannot work out the best/simpliest way to do this. I would like a listbox on my form, So I can easily add or remove items directly by clicking on the listbox for ease & clarity. value list is almost perfect but v.occasionally might want to change those items and that data is not saved...

Hi, Sorry this is a little vague but just have no time, on holiday tomorrow & only have a few hours later. I know this copy & paste is not pretty but worked for years. Works well with keeping rtf formatting Get error, "paste is not available now." This Windows 10 or Office have done a...

Hi, Really odd one this, I load unread emails from outlook, works 95% of the time, no error. From time to time & it seems on emails that are similar, I suspect identical duplicates! it will crash, array out of bounds. I am guessing when I mark as read, it then gets confused reading the next...

Hi, Been using code below to send emails for years, all worked well. However my service provider recently moved my server over to what seems like a DoDaddy service & ever since sending emails has slowed down. NOT the actual receiving at the other end, that's not too bad, but from the second I...

Hi, I have a table with each day & totals related to that day. Dates will vary and number, perhaps 20 or more but I think will restrict to 30 although data may ask otherwise but will have to worry about that on the screen space. I know not really how access is meant to process, display data...

Hi, I am trying to sum total the two values as below but Grouped per day ONLY, 1 total for the 7th, the 8th etc. etc. However I need the TmHour to filter the results just between those times This causes it to no longer be grouped by day but per time hour also. I just can't work this out, any...

Hi, Very strange problem, using the code below, I have a button that delete's the current record, sometimes it works as expected, sometimes does not delete the record but more oddly it deletes a record on a different form, the form is a main menu A, is open but not even the calling form so when...

Tricky to explain, I have 4 or 5 front ends connected to a BE on the same LAN. They have the same name. I might be over complicating this but ideally would like to be able to identify each front end. FrontEnds are on C:\Documents etc. etc. not the same location Pc to PC e.g. pressing a button on...

Hi, Think should be able to work this out for myself but struggling I have a form with a web browser control. I want to view the pdf then decide which folder to save it to, so after closed immediately have the choose folder (ApplicationFileDialog.. stuff I open the form, then once open &...

Hi, Have quite a complex form, lots of fields (need them all on one screen) Would really like to use databars to show rough amounts on 2 fields, at a glance However they are slow to display & the whole form is "calculating" for 7 to 15 seconds, & again if you scroll down, perhaps 30 records in...

Hi, Not sure would help anyway but don't want to use the Forms reference as not used elsewhere. I have code that loops through records & creates a large string/text field e.g. AllDatesX = " Bob 1 June - 10 June : OK Jack 15 July - 20 July : Not OK Jim 20 Aug - 25 Aug : OK" inc. CRLF etc...

Hi Not too good with regular expressions, I have below which returns "15th" Ideally I would like it to just return the th, nd, st part ResultX = RegExSearch("15th December", "\b(\d+)(st|nd|rd|th)\b") I could simply use Right(ResultX,2) but did just think this is probably done in the pattern...

Hi, large RTF text field. Is it possible to Strikethrough text, similar to Ctrl B bold, U underline etc. I suspect not as it does not come up when you drag & select text, where you can change font & colour etc. I image some way could add html tag via VBA but as not that essential not worth the...

Hi, I have a button that sends an email, via MS Schemas, OLE etc. Run on a button single press If I accidently press this twice, almost like a double click, it runs the code twice & freezes & sort of crashes, recovers usually but 30 seconds. I wondered if there was a simple, elegant was to stop...

Hi, Got code below from somewhere else & works FINE if Outlook Options are set to open on the calendar I want it to open on a specific inbox but I get an error "Object variable not set" oOutlook.ActiveWindow.WindowState = 1 ' causes the error I assume perhaps not quite fully open because...

HI, On Forms mostly but also on reports. Condition Format on Unbound field won't work. e.g. FieldX e.g. Value < 0 highlight in red often won't work, but perhaps 50% of time it will, does not seem to matter what the number is -6 is not red, - 11 is red & random number it seems. If I use...

Hi, I have a rtf field (emailreply) on a form. It is made up of simple strings & other fields e.g. me!emailreply = "hello" & me!Names & "how are you" & "this is your address" & me!Address me!Names is a field & textbox (normal NON rtf) if Me!Names is "Bob & Jake & Jill", when me!emailreply is...