John Sh's latest activity
-
JJohn Sh replied to the thread Solved Afterupdate with no update..FWIW, here is the sub. Called from the current control's gotfocus event with "isanythingthere me, me.nameofnextcontrol" Public Sub...
-
JJohn Sh replied to the thread Solved Afterupdate with no update..NO, Doc_man. The controls are placed top to bottom and the auto tab goes left to right. I have solved the problem using the gotfocus...
-
JJohn Sh replied to the thread Solved Afterupdate with no update..Hi Ken. That is the simplest method but we're not working with people who are very adaptable. They will click on every control and...
-
JJohn Sh replied to the thread Solved Afterupdate with no update..That didn't work because the focus changes when you release the mouse button on the dropdown arrow. You don't get to see the dropdown or...
-
JJohn Sh replied to the thread Solved Afterupdate with no update..Thank you all. I finished up using the mouseup event. Obviously the mouse down event works equally well but feels a bit too...
-
JThis is probably a dumb question, but I have a combo box that gets focus with the correct data. When I click on the combo box there is...
-
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
