Recent content by John Sh

1) I need to open the files during their construction. It helps me see if the sql strings are doing there thing. 2) This behaviour happens on un-indexed and unfiltered files. I didn't get a chance to test at the uni today, so no results there. John

I have the system running on 10 and 11 at the uni so will do a few tests tomorrow. Watch this space!

I only have one machine with MS Office, so unable to test here but I can test it at the Uni tomorrow. The drivers are probably standard windows drivers, I have never had cause to question them and I am using Windows Defender as my only AV software. Re the CPU update. All this hoo haa about...

Lots to ponder here. I only use CR on close, on my development environment.. My live software is all accde and the backend is backed up after every use. I do have a mouse issue when the batteries are a bit low but that is mainly erratic movement and I have just replaced them without affecting...

1} No. 2) The test accdb is regularly replaced with the active file, although I don't delete one and paste in the other. The behaviour has persisted over multiple copies of the accdb. I have to replace my very old cpu with one compatible with W11. I'll see if that makes a difference when the...

I do a compact and repair on close so corruption is unlikely. Also everything else is working as expected. It just starts for no apparent reason and sometimes just stops doing it. Usually restarting Access fixes it for a while. Just a nuisance really, especially when trying to sort a field.

From time to time, in table view. I get this strange behaviour. I am running Access 2019 and still on W10. First image, Open table view. The first field is already highlighted. Second image, select "Main_Family". All fields to the left are highlighted. Third image, select record 107. All...

Thanks for that. My only observation is that "as_date" and "as_String" rely on a "Null" value but don't consider an empty string. Maybe "NZ()" rather than "isNull" would make them more reliable. Function As_text(cur_text As Variant, Optional on_null As String) As String If nz(cur_text,"")=""...

You have piqued my interest so fire away

Thank you. I have implemented IMB's approach. I have converted all of my sql strings to this format with a couple of search and replace passes.

I like the concept. You have in instant visualisation of you mistakes, or you don't make them in the first place. Thank you. John

I know you professionals like every thing to be tickety boo, but! I have inherited a "system" that was thrown together in the 70's and grew like topsy from there. To say it is a poor design, implies that there was a design process in the first place. That being said, it is what it is and I have...

I do usually use a similar format. Vis variable "sQry" is declared private in a module that holds many SQL strings sQry = "xyz" odb.execute sQry, dbfailonerror Once the string is working correctly I will transfer it to this module in that format. I prefer to get things working in a separate...

To achieve the results I need, I have to do a series of findfirst operations and it simply takes too long. Using SQL is many times faster.

Thank you. I should have realised those spaces were missing but the harder you look, the easier it is to not see. The second part of my query was how to include the "Notes" field using the sStr variable. E.g. Public Sub inToDisc(dFamily As String, sFamily As String, nAccno As Double, sStr As...