John Sh's latest activity
-
JJohn Sh replied to the thread Solved SQL problem.I'm running Access 2016 and currently running an update. I am writing the sql in the vba editor. OK. I've run this after the update and...
-
JJohn Sh replied to the thread Solved SQL problem.I appreciate the reduction in typing and will implement that. I actually did know that but typed the extra anyway. Back to my original...
-
JJohn Sh replied to the thread Solved SQL problem.It's complicated, but. 1) run a scan of all the relevant raw files using a recursive function. Every specimen in the collection has been...
-
JJohn Sh replied to the thread Solved SQL problem.The booleans are independent of each other and can be either true or false. They are the result of a series of spell checks. If any one...
-
-
JI have a series of 5 boolean controls where any one of them being true will cause text in a control to change. I can't get the code to...
-
JJohn Sh replied to the thread Solved searching with a partial string.The existing data errors are confined to the older entries and do not affect current data input, so it is mainly a case of cleaning up...
-
JJohn Sh replied to the thread Solved searching with a partial string.I have created a form that has all the inherent errors in the main table with links to spelling corrections, duplicate entries...
-
JJohn Sh replied to the thread Solved searching with a partial string.The "findfirst" statement that works The code that finally worked is a slight variation on your suggestion, rs1.FindFirst "[family]...
-
JJohn Sh replied to the thread Solved searching with a partial string.Thanks to all. I will try "like" and see how it goes. I haven't heard of "Simil" but will have a look at it and MajP's demo. The...
-
JI have a situation where a number of entries have been mis-spelled and I need to find the correct spelling in a reference list. As an...
-
JJohn Sh replied to the thread Closing image viewing software.Good morning David and thank you. In the load event, "sViewer = Photos.exe" . This is passed to a shell object and opens whatever the...
-
JJohn Sh replied to the thread Closing image viewing software.Some of the computers are on a uni network so should be using the same viewer and I can control that to a certain degree. It's the...
-
JJohn Sh replied to the thread Closing image viewing software.Thanks David. My description maybe misleading. Firstly, I am displaying 70 mb NEF files that Access cannot handle, so have to use...
-
JJohn Sh replied to the thread Solved Conditional format problem.Thanks. I'll give it a try.
-
JI am using the following code to open a picture viewer via vba oShell.NameSpace(0).ParseName(sPath).InvokeVerb "Open" Then this code...
