Search results

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.

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, Many thanks for your reply, Really sorry is a bit of a mess, I just copied & pasted from the VBA, had quickly to go off an do something else and thought post it quickly without reviewing & hope for a reply rather than leave another 24 hours before chance to tidy up. You were right about...

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, Not sure persistent connection is the problem, although I am no expert. Running the loop 100 times I would think it has not disconnected also I have run it with the table actually open. Public Function VatRateDate(DateX As Date) VatRateDate = DLookup("[VatRate]", "PricesChanges"...

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

SOLVED Hi, Many thanks for your replies, typical as soon as I asked the question I found the reason it was not working as expected. From the previous form that opened this new form with calculations, I had some code AFTER the openform command, this code would have run after and in fact had an...

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

FirstBookedDogs = Format(DMin("DogsModDate", "[DogsModDate]", "[DogsID] =" & DogsID & ""), "dd-mmm-yyyy") DogsModeDate is both a table & one of the fields (I don't normally do that but sure oK) It is a table that I link to the main Dogs table using the ID's Most fields indexed. Whenever the...

Thanks for your reply, not easy to post a copy, data is private'ish and not easy replace enough of it with dummy, also a linked table. I tried a nested query & just as bad but perhaps goes back to the root query to refresh What is weird is I removed all the date range criteria so it had to go...