John Sh's latest activity
-
JJohn Sh replied to the thread Table view problem.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...
-
JJohn Sh replied to the thread Table view problem.I have the system running on 10 and 11 at the uni so will do a few tests tomorrow. Watch this space!
-
JJohn Sh replied to the thread Table view problem.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...
-
JJohn Sh replied to the thread Table view problem.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...
-
JJohn Sh replied to the thread Table view problem.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...
-
JJohn Sh replied to the thread Table view problem.I do a compact and repair on close so corruption is unlikely. Also everything else is working as expected. It just starts for no...
-
JFrom time to time, in table view. I get this strange behaviour. I am running Access 2019 and still on W10. First image, Open table...
-
-
JJohn Sh replied to the thread field variables in sql string.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...
-
JJohn Sh replied to the thread field variables in sql string.You have piqued my interest so fire away
-
JJohn Sh replied to the thread field variables in sql string.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...
-
JJohn Sh replied to the thread field variables in sql string.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
-
JJohn Sh replied to the thread field variables in sql string.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...
-
JJohn Sh replied to the thread field variables in sql string.I do usually use a similar format. Vis variable "sQry" is declared private in a module that holds many SQL strings sQry = "xyz"...
-
JJohn Sh replied to the thread field variables in sql string.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.
-
JJohn Sh replied to the thread field variables in sql string.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...
