Search results

  1. B

    Forms conditional formatting & DataBars, v. slow. Is there an alternative or way to speed up? The numbers are shown instantly

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

    Forms conditional formatting & DataBars, v. slow. Is there an alternative or way to speed up? The numbers are shown instantly

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

    VBA to construct a string, then add RTF formatting so can be Pasted into a memo field

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

    VBA to construct a string, then add RTF formatting so can be Pasted into a memo field

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

    VBA to construct a string, then add RTF formatting so can be Pasted into a memo field

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

    Regular Expression to return only part of the search. e.g. find "15th" but return just "th"

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

    Is is possible to Strikethrough text in an RFT field using keyboard shortcut.

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

    Prevent two fast single clicks in succession on a from button - prevent code being run twice by accident

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

    Check if Outlook is fully open? Outlook/Options, Start on calendar OK, start on inbox gives error

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

    Condition Format on Unbound field won't work e.g. Value < 0 but exp [FieldX] < 0 does work

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

    Inserting textbox of "Bob & Jake & Jill" into rft field results in "Bob& Jake & Jill"

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

    Inserting textbox of "Bob & Jake & Jill" into rft field results in "Bob& Jake & Jill"

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

    Inserting textbox of "Bob & Jake & Jill" into rft field results in "Bob& Jake & Jill"

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

    Inserting textbox of "Bob & Jake & Jill" into rft field results in "Bob& Jake & Jill"

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

    Inserting textbox of "Bob & Jake & Jill" into rft field results in "Bob& Jake & Jill"

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

    Inserting textbox of "Bob & Jake & Jill" into rft field results in "Bob& Jake & Jill"

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

    Change or grey out custom right click menu options depending on focus. I have procedures that run off normal right click

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

    After Update, stay on Same control but sel.start sel.length to highlight it

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

    After Update, stay on Same control but sel.start sel.length to highlight it

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

    After Update, stay on Same control but sel.start sel.length to highlight it

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