June7's latest activity
-
June7 replied to the thread Solved SQL problem.A VBA expression where 2=True would return False. Null=True returns Null and in an IIf() that would evaluate to the False condition... -
June7 replied to the thread Solved SQL problem.AFAIK, a Yes/No field cannot be Null. It is either True or False (-1 or 0). However, since Null is not -1 it would be treated as False.
-
June7 replied to the thread Solved SQL problem.Again, I tested that criteria and it worked for me. Could provide you db for analysis.
-
June7 replied to the thread Solved SQL problem.Sort of agree, Doc. Adding parens shouldn't hurt but not having in complex JOINs can. And for even less typing, don't need = True or =...
-
June7 replied to the thread Solved SQL problem.This is not valid UPDATE syntax. FROM belongs with a SELECT. John, I tested your syntax (without the bad "or") and it works for me...
-
June7 replied to the thread Adding outlook.recipient values to an Access table.Please define "render" in this context. If you are trying to input a string that exceeds 255 characters into a Short Text field, that...
-
June7 replied to the thread White Space in Reports.As already suggested - make subforms really small (0 height), virtually a barely visible line, then position them almost touching each...
-
June7 replied to the thread VBA - SQL - As String Questions.Because the SQL engine will process the SQL statement and "find" the function and evaluate. Just as if you had referenced the function...
-
June7 replied to the thread MySQL Server Question.Would these remote laptops even have reliable internet connection? Have you tested connecting remotely using command line commands? From...
-
June7 replied to the thread MySQL Server Question."In the field" means they are not on the same network as MySQL server. They would have to connect over internet, maybe via VPN. MS...
-
June7 replied to the thread Solved Help adjusting chart's min/max Y-Axis value using code.Instead of hijacking a 4-year-old thread, should start your own. New threads get more attention. Reference the old one if you think it...
-
June7 replied to the thread Incremental Sequential Numbering by Year via Calculated Field.No, this cannot be accomplished by a simple calc in table. Generating custom unique identifier is a fairly common topic. I had to do...
-
June7 replied to the thread Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?.I doubt the base set can be modified. Why is this needed? Do you want to limit user's color choices to a defined set? How many colors...