Search results

Hi, I have a continuous form. It is mostly filtered via a text box at top, ie. I type a surname The Recordsource Query (although SQL in the RS & not sep query) then filters the form from the query that has Like [Forms]![MainForm]![surname] & '*' works fine. I also have a search textbox to...

D'oh!! SOLVED & feel rather stupid. Removing the navigation pane made the continuous form window wider & brought into view a small text box that actually held a lot of data. I had it in a tiny box but still visible. It seems that because it was trying to display this memo field perhaps 20...

Hidden Navigation pane SLOWS continuous forms refresh Hi, Running my DB with the Navigation pane (shutter) hidden make continuous forms display very slowly. Whether closed in settings, Via VBA or simply not show because I have used /runtime. Same on the accdb or the compiled accde. It is the...

SOLVED. Hi, Thanks again for all you help, Just to confirm that the problem was caused by Malwarebytes Anti-Malware. I uninstalled and all is fine, I could not be sure until I had a good day to test. I know perhaps I should have considered AV from the start but it was such a weird & specific...

Hi, I really appreciate your efforts here. I think & hope it is MalwareBytes!! In case I have just been lucky for 10 minutes to cover your points. I did think virus's. I run a full defender scan & it was OK but it was this that made me think Malwarebytes as I like to run this also & it is in...

Hi, There is nothing in the logs to indicate any issues or errors. In frustration I thought I would upgrade all to Office365. Really did not want to but after most of the day trying anything I can think of run out of ideas However much to my horror (little strong) it has not helped!! So far...

Hi, it's only me who does anything techy with the computer, just a few other users I know would not touch anything else. Page file pc1 4096 Windows control, pc 2 8096mb, both pc well spec's but is only 4gb ram on pc 1. Its just I think too much of a conisidence that a few days after lots of...

Hi, Thanks for your reply. Never happens on local #1 PC even if PC #2 is running the FE (or not so far but think it would have by now) Not had much chance to test but so far has not done it on #3 PC which is runtime only (No full install or recent updates) Only error's on PC #2 & does...

Forgot to say, When I open the back end directly it Auto recovers no problem, all data fine. It does feel like a network interuption but as it works fine if #1 FE is not running and looping speed test show 300mbps and no fail. Bit more info. Update for Windows 10 Version 1607 for x64-based...

Hi, Getting the above error after a few changes of data, but not immediately. Not changed or done anything different (perhaps a Windows update a few days ago but sure fine since then) Windows 10 on all PC's. All been fine & 100% for years (never had corruption) Access 2007. Full ms access...

Hi, Currently all PC's running 2007 and I have a runtime accde on 1 PC (Access not installed). The Back End is on a 2007 PC. This PC just died & trying to get running on a new PC that is the only one with Access 2010 installed. (I could uninstall but prefer not) Struggling with references on...

Hi, I have a Rich Text Memo field (data of course Rich Text) When I am entering text, if I press Enter or (Ctrl+Enter) to get a blank line/spacing between lines the blank line always has a space in front of it. (You have to refresh the page for this to take effect otherwise looks line) This...

Solved Thank you so much for that, such an obvious, simple & clean solution I did very briefly try but for some reason did not work so well and gave up rather too easily as this time sorted in minutes & have a great solution that avoids so many of the other pitfalls. Thanks again.

Hi, Thanks for the "This adds a date to a textbox and selects the year part." example. Is does not quite correspond to what I am trying to do as when you mouse click, all is fine, it is when forcing move focus via Tab or Enter from keyboard but NOT in the natural tab order. In your example...

Sorry that was a typo, I have so many bits of code, most ' rem'd out Field2 Got Focus With Me.Field2 .SelStart = 1 .SelLength = 0 ' Nothing selected End With I am pretty sure now it is because the TAB or Enter keystroke from the previous control is carried over and still firing on Field2. I...

Hi, that does not work either in this setfocus situation I have generally been using this anyway so assume would always be no selection With Me.Field2 .SelStart = 1 .SelLength = 0 ' Nothing selected End With I have since tried on a different access installation all together, Access...

Hi, With just that line of code it does work as I would wish with natural TAB order, moving from Field1 TO Field2, it will move to cursor position 1 & not highlight/select & that would be great but as I say I need it to move from somewhere other than the natural TAB order and the second I...

This is just a test database, My main database I use the keyboard & do not want to use the mouse. I want to be able to press Tab (usually) or enter from a variety of controls, go to a memo field and be ready to type, without deleting everything (because its is selected) I cannot use the...

This really is begining to wind me up, I see what you were getting at but did not help. If I have a button that runs the selstart sub & mouse click on it, it all works but if I call the Sub it does not, it needs the physical click onto the form, setfocus to the button does not help. Just don't...

Is this what you mean? Calling this separate Sub still selects/highlights the whole field or am missing something else. Tried it in the Field1 OnExit event also. Private Sub Field1_LostFocus() Call MyField2SetFocus End Sub Private Sub MyField2SetFocus() With Me.Field2 .SetFocus...