Recent content by John Sh

I have had a couple of indicators. Apart from the seemingly random behaviour of various forms, I discovered that the accdb file I had used a couple of days ago was unreadable yesterday. I went to my backup files and the directory was unreadable. Many years as a service technician tells me that...

Thanks but I'm not sure it's relevant. I'm only using a single monitor in the real life, accde, situation and I don't think an auto centered form can be repositioned.

Something I can control. If I change the misbehaving forms to "Auto centre" on, popup on, modal on they appear on top, When I turn "Auto centre" off they go behind. This is good in that I can see the form, but bad in that I cannot control the popup form's position. I have tested this with a few...

I haven't given the Z order any thought but it's certainly worth considering. Thank you John

Elmer Fudd was wise beyond his years, My next approach is to start a new database using some of the existing code and try to cause the problem to show itself. The uni problem is that while I have access to the operation of msAccess I may not be able to address msAccess.exe to use the command...

Thanks DocMan. A very comprehensive and easily understandable explanation. I have decompiled the accdb following the advice here, https://www.devhut.net/ms-access-decompile-a-database/. I reopened the files in a new, blank, database and the problem still exists. I have scanned my computer for...

Thanks. Nothing ventured, nothing gained. John

Understood. The object "odb" is declared Public in a module. I should have noted this. oDB simply replaces "set db = currentdb" and uses the same object rather than creating a new object each time. Re DevHut, I think. Re no tables, it's not that simple. I would have to include a goodly portion...

Thanks Tom. I will give it a try, but what am I looking for in the decompiled code? I agree that the string change is not the problem but it seems to have triggered the change in behaviour. Almost as if the system was waiting for any change in the code to trip it into fail mode. The code...

For a while, Access seemed to be behaving until I changed the text below, from Me.btnShow.Caption = "The Family '" & Me.txtFamilyIn & "'" & vbCrLf & _ "Is not on the Taxon list." & vbCrLf & vbCrLf & _ "Please check the hispid sheet, for the...

Currently running 2016.

Hi George. I edit my SQL in the standard VBA editor. I'm not aware of the "Monaco Editor". Should I be? John

I do have quite a bit of Access SQL and , so far, it doesn't appear to have been affected.

KitaYama. Thanks for the comprehensive list. My aim isn't so much to avoid using Edge, I steer well clear of it. It's more part of debloating Windows. My understanding is that in Europe you can remove edge without causing problems. There is a switch within Windows that enables that. One can...

I think Chrome is a licence for Google to steal your data. Never tried Brave. I've been using Firefox since it came out and never had a complaint. I'm marking this as solved. Thanks to all that contributed. John