Search results

Hi, Thanks for your prompt replies Took my own advise & making a table & then the form is based on that, so far very fast but a bit of coding to fully implement but not too much. Its strange, done this a few times, really stuck on a problem, think to ask for help and whilst trying to explain...

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, Weird, my login was rejected so slow to reply, OK now, same user & PW, anyway.. Sorry was lazy typing, I do use <b> for bold etc & <br> Crlf It is not hard to re-code some stuff to use a text field on the form but ... aHTMLBody = "This is a <FONT size=5><FONT color=#800000><strong>TEST...

Hi, thanks all for very fast responses. I did try <br> , a bad example <strong> for access rtf. Nothing seems to works in an string variable, using a form field will. I am probably over complicating, I was trying to avoid using a me.field, constructing there, setting focus & using...

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

The Saga continues, re-visiting anyway. Mostly use of this field/data is RTF, emails I send out etc. However I also now want to remove the html when it needs to be a TEXT/SMS. on a mission now to find out what is going on.. All below is using the same me!LetterSource, a rtf field in a table I...

Just for ref. rather given up trying to find out but if anyone does know off hand, Replace(Me!PetNames, "&", " &", , 1) does fix easily, although I have a lot of places I need to apply. thanks for any replies.

Even more confusing, I have it set up so I can view exactly the same data but on a plaintext control so it shows all the rtf/html tags, as below, just different names, Bonnie & Lulu & belle, you can see the space is there <div>I am pleased to <strong>confirm</strong> the booking(s) as...

In the caption I understand why especially on buttons etc. to act as if pressing using the alt key but why on the actual underlying data. I know rtf fields do behave differently with all the html and perhaps inserting a non-rft into a rft field can really complicate & cause unpredictable...

Hi, Yes, double space after Bob is reduce to single space, I can program to sort but just seems odd (and unnecessary), especially as does not do it to the others after, I could sort of appreciate the ampersand causing issues but why only the 1st.

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

Hi, Just getting into custom menu's, They work well but would quite like to ideally grey out or hide menu options that should not be available depending on where the focus is. I can of course test & stop if running but prefer its not obvious to use from the drop down menu itself. CUrrently...

Good job Trump still not in charge as that would be his next advise to beat covid, A good gargle of bleach whilst executing a SendKey statement. Back to SendKeys "+{TAB}", of course I realize what it is doing now, on moving to next control it Tabs back, did not fully appreciate the action and...

Unfortunately this does not help, always known how to use .SelLenght etc. I use it a lot. Me!OutDate1.SetFocus Me!OutDate1.SelStart = 0 Me!OutDate1.SelLength = Len(Me!OutDate1.Text) It is something about AfterUpdate & not moving control. If it naturally Tabs to next control & back again it is...

Many thanks, All these years! I must admit I was always advised to avoid sendkeys (not sure why) but such a simple & working solution is not going to be ignored.