Search results

For those interested, what I came up with is as follows. By way of background, the Access methods and properties all place the form in question in, or relative to, the Access client area, or canvas. My objective, however, was to mimic Windows Aero effects and place it relative to the screen...

Not necessarily. The NTFS / Windows authorization construct indeed is incapable of establishing user or group permissions for files. The best it can manage is to enforce them at the directory ("folder") level. So, a hacker with file access has full access to the code. Still, if objects...

I'm not wasting my time by asking questions. And again, don't mistake rigor for advocacy. The question then becomes, by whom? I'm not looking to fend off the NSA or the GRU. Holding off meddlers and laptop thieves is more the objective. The mathematics of probability tell us that the...

That is (or those are) the questions, of course: Are these deprecated or hidden for security or other reasons? If the former, why (and specifically what is meant in this case by being "deprecated"), if not, are they usable in whole or in part, why or why not, and if so, how? Seventeen years...

@The_Doc_Man , that's interesting, and thanks. You've sparked my curiosity. I understand you to say (more or less) that the data structures remain but the code referencing them has been disabled or removed. If you know, what did the msaccess.exe code referencing these data structures do (or...

That's not hard to imagine. 2007 was a heavy lift and a number of things (e.g., abjuring a property to configure Form.Mousewheel behavior for an unconfigurable change in behavior) seem slapdash, driven by product marketing deadlines. It's also not hard to imagine, e.g., that the Active...

Pat: Thanks for responding but why is it that they aren't useful, though? Do they not work with ACE or an ACCDB? The properties and objects seem well designed, and close or identical to what I'd think to implement in their absence. Is there a reason not to use them? Besides that being a...

I've been aware for some time that ACE hid a number of objects and members (i.e., properties and methods) that previously had been exposed in JET / DAO 3.6, in the 2003-2007 transition. The Group, Groups, User, and Users objects are hidden altogether, as are properties such as Owner, UserName...

I'm not programming at that level but that makes perfect sense. A variable has to be a data structure of some sort. A Null return based solely on a type evaluation would be computationally more efficient by gating address or value evaluation with a bitmask, which then also would provide a...

Because that's what prints in every other case of Null.

Further through the responding posts, you'll see that the expression's return value is Null but it prints the string "Null" (without quotation marks) to the Immediate pane, instead of not printing anything. Str(Null), Hex(Null), and Oct(Null) all do the same thing.

I guess so. I just looked it up myself (Section 2.1): "A single distinguished value corresponding to the reserved identifier Null" represented as "An implementation specific bit pattern " So, definitely a constant. I wonder what the bit pattern is. Str(Null) also prints (not returns) Null...

The thing is, only a Variant can contain Null. Also, for this reason, Null propagation by use of the + operator wouldn't occur were a string variable to be concatenated similarly. If the string variable were uninitialized or expressly set to "" (i.e., a zero-length string) or vbNullString...

I'm not certain that Null is a constant but leaving that aside, I think George was on to something by suggesting this behavior is the consequence of an evaluation. Delimiters trigger evaluation in VBA and Windows, and in Bash, for that matter. Octothorpes trigger evaluation of date literals in...

Very good questions, actually. I was just framing out two or three generic upstream helper functions to do some small things (mostly relating to delimitation) to facilitate dynamic construction of SQL statements and criteria expressions when the behavior manifested. I've exploited other...

Len() (and LenB()) are two tests I hadn't attempted. I tried them just now and both return Null, which one would expect for a Null input but not for a string. This said, I tried a number of other things all related to evaluation or type conversion in one form or another, so you may be onto...

Actually, I've been tinkering further and this (inconsistent output to memory and the Immediate window) seems exactly to be what is occurring. I tested a variety of means to obtain or assign the string output, without success. Given the input I described, the VBE, as compiler / command...

George, this illustrates and confirms the behavior of my "TestTheTest" function, which is that the return both evaluates as Null and prints the string.

I've been tinkering a bit. If concatenated with &, Null returns; if concatenated with +, "Null" returns. Expanding the original function a bit and adding a test function (with the Immediate pane output commented by line) illustrates my observation. What's interesting is that the test function...

Perhaps this is new, or just new to me, but I just learned that a string that concatenates a Null Variant variable between octothorpes using Null propagation (by use of the + operator) does not return Null but rather the string "Null" (without the quotation marks). This can be handy but I just...