Search results

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

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

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

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

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

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

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

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

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

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

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

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

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