Recent content by bignose2

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