John Sh's latest activity
-
JJohn Sh replied to the thread When "X" is not equal to "X".Me.cboTables.Requery isInFocus "cboTables"
-
JI have the following code snippet that refuses to do as it is bid. The idea is to catch an inadvertent "setfocus" to a control that...
-
-
JJohn Sh replied to the thread Followhyperlink alternate.I'll give it a try. I ran the code today on two w11 machines and there was no problem other than on one machine the entire software...
-
JJohn Sh replied to the thread Followhyperlink alternate.Thank you but no help. The URL has HTTPS:// built in and my problem is not security warnings but a "Mini" crash that fixes itself after...
-
JJohn Sh replied to the thread Followhyperlink alternate.I just tried it with a couple of short image links with the same result. Debug thinks it's all good but there must be some obscure thing...
-
JJohn Sh replied to the thread Followhyperlink alternate.Thank you but they both behave in the same way. Is it possible that the 3D imagery is having some effect?
-
JAfter having problems with followhyperlink I searched the net and found this site...
-
-
JJohn Sh replied to the thread Using a variable in sql query.!) I have inherited a database that, by it's very nature, holds various tables with "similar", not "the same", data structures. Yes, it...
-
JJohn Sh replied to the thread Using a variable in sql query.Thanks again June7. I just figured it out myself, with a bit of help from GPGeorge. "FROM [" & sTable & "]" & _ I completely forgot...
-
JJohn Sh replied to the thread Using a variable in sql query.Thanks GPGeorge. I'll try that. As or the warnings I usually wrap such things in a setwarnings pair.
-
JJohn Sh replied to the thread Using a variable in sql query.Thanks June7 but I now get a syntax error in the From clause. I tried "From ' " & stable & "' " & _ with the same result. If I put the...
-
JI have scanned the net and got so may different answers, that don't work, to this question' I am trying to replace the "From" clause...
-
JJohn Sh replied to the thread macro or function preventing saving date to a field..setting the combobox to itemdata(0) has fixed the problem. Even with break on all set, there was no indication of an error when the...
-
JJohn Sh replied to the thread macro or function preventing saving date to a field..Well that wasn't it. I have renamed txtcreatedby to cbocreatedby The cbocreatedby combobox has a list of three names. If I select the...
-
JJohn Sh replied to the thread macro or function preventing saving date to a field..I have never had cause to use "beforeupdate" so that's ruled out. It seems the problem is caused by a sub that has "on error resume...
-
