Search results

Understood. I changed that setting some years ago, for what, at the time, seemed a good reason. To change it back, now, involves changing many, many, queries so I'm going to leave it as is for now. I thank you all for the input. John

Replacing * with % did the trick. ArnelGP your solution did not work. I finished up with rs.findfirst sField & " like '%" & sStr & "%'" Thank you both. John

I know this is an old dog but it still has a bite In the code below, sStr can be a string or a "number" If it is a number then findfirst returns not rs.nomatch If sStr is a string that is exactly the same as the field value then success. If sStr is not exactly the same as the field value then...

Indulged you are, and Yes it fixed the problem. I only had to remove the blWrap clause as I finished up with "##" around the dates. I'll remove both the optionals as they are not required. Thank you for the code and the lesson. Much appreciated. John

Sorry but you're wrong. A date "28/02/2024" would imply 28 months to the year, by your reckoning. Also the filter string is not used in SQL, it is passed as a string to me.Filter. This code is in a separate form where the user can select the filter criteria. fDate and lDate are a catchall if...

It is international standard date format so "dd/mm/yyyy" Not that it would make any difference, as long as all my dates were of the same format. John

No spaces.

I have a filter on a table that includes the date, formatted as date/time. The controls are formatted general date. The filter works if the first and last date are different but returns a blank screen if the dates are the same, even though the times are different. How do I get around this? I...

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