John Sh's latest activity
-
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...
-
JWhat is your question? Do you have an error? It looks like you need an extra space at the end of the above: "WHERE A.Main_Family ='" &...
-
JIn the SQL string below, the "Main_Family" field needs to be controlled by the variable "dFamily". I need to run the same basic SQL with...
-
-
JJohn Sh replied to the thread Persistent laccdb file.Sorry Docman. A simple typo has led you astray. I did, of course, mean the laccdb file and not the accdb file. My 86yo fingers don't...
-
JJohn Sh replied to the thread Persistent laccdb file.Hi Docman The drive X only holds the data for my development files so no damage done to the active files. X was disconnected, and the...
-
JI had a situation where the external drive, holding the remote data files, was removed before Access was completely shut down. This left...
