Search results

You could also search in the VBEs 'Object 'Browser' for 'acNormal'. There you can see that it belongs to the enumeration 'AcFormView', which makes clear that it's not to be used with the 'BackStyle' property.

@Imb : I would also be interested to see in a sample database how you replace two or more cascading combo boxes in the UI with whatever (you said you don't use any). I assume you are not replacing them with listboxes.

So your real-world controls are virtual controls whose properties and behavior you define in tables and implement in Access controls when loading a form, for example? Or have I misunderstood you? Can you explain your idea in a little more detail?

Hmmm, but you just explained yourself that this is a WHY comment after all: You then seem to explain why you have implemented something the way you did. ;)

I know that only too well. Finding good names is not easy and lines become (slightly) longer as a result, but I like code that reads like a book. Regarding the additional comments you mentioned, which you like to add from time to time: There is a risk that these become obsolete when the code...

@Edgar_ : Your coding style is very close to mine, I like it! But one question/hope I have: Your comments are just explanatory in you post here, or? Because in my eyes, comments should (mostly) only tell the reader of the code the "why" and not the "what" or "how".

If it is like you say, then you could use the following code to extract the information of the string which has been read from the file. The constant 'LINEBREAK_TO_USE' should be 'vbCrLf', 'vbCr' or 'vbLf', depending on the line break used in the file. The variable 'source' ist just to hold...

Hm, apparently I'm the only one who recognizes this as a plus in terms of clarity and appreciates it. It's all a question of habit. ;)

I would ask again friendly whether implementation would be possible?

I just feel comfortable with the use of the 'Cryptography API: Next Generation' in contrast to 'Rnd/Randomize' and don't have to worry about whether the random numbers are ‘sufficiently’ random.

I agree with @The_Doc_Man Apart from that, the pure VBA solution is not really random. As far as I know, the 'Rnd' procedure always runs through the exact same (very, very, long) number line, which is fixed internally. The 'Randomize' procedure merely ensures that the current pointer, which...

Ah, ok. That would be possible, right. What I had in mind was that I often use such a construct, where I don't have a variable at all, but only the 'With'-context: With New MyClass ... End With

Can't follow exactly, David. Which variable do you mean to add a watch on?

One disadvantage of 'With' blocks, in my opinion, although I like to use them quite a lot, is that you cannot examine the 'With' context (i.e. the non-existent variable) in the 'Locals' window when debugging.

It is certainly up to the operating system (perhaps even the CPU) to decide which instructions of the (single) VBA thread are given to which core for processing and when. And if only one of the cores executes an instruction (from VBA) at a time, the others get bored in the meantime.

One point that should not be ignored is that in the case of the distribution of the product, it may happen that customers who use it may unfortunately still be using an older Microsoft SQL Server than 2017. Therefore, 'FOR XML' is the more compatible variant.

The main reason for this will probably be that VBA code is executed single-threaded, i.e. always with only one core, regardless of how many cores the processor has. The single-threaded performance of a CPU is therefore more important for Microsoft Access than the multi-threaded performance...

The forum has posting numbers. Your last one was #6 (take a look on the right side of your posting). Mine is #7. You can also get a link to that postings. The posting you meant is #3, right?

Puhhh, long ago... Microsoft Access 1.1 for me. 1993

But that's a gamechanger. Your script is fine, but one can't use it.