June7's latest activity
-
June7 replied to the thread Search box to find parts to add to job instead of a combo box.Could have code filter combobox list based on text entered. Similar to http://allenbrowne.com/ser-32.html. Modify to use wildcard on... -
June7 replied to the thread How to read IP Address of 'actually used' lan nic?.I see that now. I used cmd window to output IPConfig info. I have 5 configurations and 4 are disconnected so I only get IP for my WiFi...
-
June7 replied to the thread How to read IP Address of 'actually used' lan nic?.Does this help https://www.access-programmers.co.uk/forums/threads/how-to-get-my-computer-ip-address-with-vba.331661/
-
June7 replied to the thread Has Allen Browne website been closed?.Yes, I already had Access Tips page open on my browser but could not open links from there. Back to all good now. Could be nice if...
-
June7 replied to the thread Solved SQL problem.?CBool("A") triggers error So CBool() understands text "True" should be converted to Boolean True.
-
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...