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, 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. B

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

    Hi, I want to be able to type data into Outdate1, e.g. press enter Process stuff on the value but keep focus on Outdate1 & highlight it, ready to type over without manually deleting. If in the AfterUpdate of the Outdate1 control I have .. Me!OutDate1.SetFocus Me!OutDate1.SelStart = 0...
  11. B

    Outlook emails, cannot mark as unread, Set oItem.Unread = False , does not work

    Hi, Have code below copied from others, I added the, Set oItem.Unread = False (with or without the "set", makes not difference) It does not mark as unread & still in Outlook & server as unread. I have seen others that loop through separately afterwards, just to clear but not tried but also not...
  12. B

    Conditional Formatting - compare to other records has 2cm bar even when value 1

    Hi, Trying for graphical representation to show a level depending on values. e.g. I have a table and the values will vary from 1 to 50. I have the textbox set up with conditional formatting using compare to other records so as to get the fill in bar chart effect. Trouble is the bar is already...
  13. B

    Does it not cache BE table data? Very slow if repeatedly access BE table (only 5 records)

    Hi Never really noticed this before, I know there is overhead with BE on local network (gigbit) but I have large tables with 10000+ records & a get minimal slow down really. However I have a BE table of only 5 records, lookup of rates depending on a dates range. I am testing as noticed in...
  14. B

    How to make sure form is fully loaded so recordsetclone is correct

    I have a form that has a form footer with totals I use to use =Sum([Cost]) but this was incredibly slow. Pleased found much faster way using recordsetclone & adding up via recordset & updating unbound text boxes, great works well if I press a button but cannot find a way for it to work on...
  15. B

    Capture "Your network access was interrupted" so can close/exit more controlled

    Hi, I have a BE on a wired LAN. Very rare for interruption but power outage or just resetting a Switch/AP without remembering to close all FE (I have 4) give me the above error. I usually have to click 5 or 6 or more close or X on the window before access closes. It can of course happen from...
  16. B

    Can you have an array as multiple criteria. e.g. HAVING (TableX.Email=""" & EmailSearch & """);" EmailSearch has more than 1 value

    Hi, Hope title is not too confusing. EmailPasteTable is a list of emails I have been sent. I call this function from a form & elsewhere LatestEmailUse("JoeBloggs@hotmail.com") It shows that lastest time e.g. joebloggs@hotmail.com emailed. also how many times but not so important. I would...
  17. B

    Apostrophe ’ instead of ' in RFT, solution that took me ages to work out. rare problem but bugged me!

    I could not find this anywhere so perhaps a very rare situation & not one to cause issues but just in case someone has a similar problem. Tried many times over many months & just gave up. May be obvious to some/most but thought mention here. Trying to remove or correct apostrophes ' in RTF...
  18. B

    Adding Criteria to a Calculated Expression in a query dramatically slows performance

    I have a query that runs normally in a fraction of a second. One of the (many) fields is DaysWaiting: Date()-DateValue(FirstBookedDogs([ID])) Admittedly quite complicated but when run, say returns 10 records in 1/4 of a second. So all the DaysWaiting numbers are show instantly so I assume...
  19. B

    Add index to existing table - is it auto indexed

    Hi, I am adding index's to a few fields in a tables that already exists & has done so for a long time, perhaps 5000 records They are date fields, few questions. 1) Is the existing data automatically indexed once I change the setting in the table, I only say as when I added them & closed the...
  20. B

    HTML (RTF) Keep format but remove headings <html> etc

    Hi, I use html & rtf in forms for emailing via access however I create my own emails and then add them in front of the existing incoming email. Problem is the incoming email often has e.g. <!doctype html> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US"> <head> <title>Test bob...
Top Bottom