@QHarr I have started the first book on the ebook list with thanks and it’s blowing my mind in some regard when you read another book in sequence after a different author talks about it.
Then with google bringing up several sites which I have subscribed to keep my ear on their pulse of topics found an interesting debate about progress bars which a doctor experimented the effect of time has on people....chrisharrison.net/projects/progressbars2/…
I’m sure a delay on vba won’t affect the computational time the user needs to wait. :)
@PeterMTaylor It is often nice to read from different authors' points of views. "Conflict if the gadfly of thought" as they say. Hopefully nothing to contradictory though :-) Thanks for the link; I shall have a mosey over to it now.
@PeterMTaylor So interesting though very small sample sizes and distinct genderbias in size splits but no discussion of any variation by. Actually only one gender identified for first test group. Seems to make sense though.
@Vogel612 I haven't forgotten I was going to look at RD regex for my [^.] problem. Just was swamped with work and then OP questions.
So... Does anyone operate with ResXManager? I wanted to continue translating today but this happened..........
ResXManager - Standalone Version. I don't have Visual Studio installed.
+- transtalion for this would be:
App can't be neither installed or run. App needs the JetBrains.Annotations version 11.1.0.0 for it to be installed in cache GAC (Global Assembly Cache).
:-/ I translated something last week. Then Saturday and Sunday happened. Now I have opened it and this appeared... Why computers, just why -_- Will try that on my personal computer...
Intro
Related, related
I'm trying to come up with a neat, accurate way of timing VBA code, as I'm yet to find a method to do this in VBA directly (without plugins etc.)
The general idea was to create some Stopwatch class which could be initialised at the start of a test procedure, then various...
I am back stuck on ByRef and ByVal. I was broadly sticking with If not changed then ByVal else ByRef. Then this, not @this, says objects are always passed ByRef. I have been passing ranges that aren't altered ByVal. Do I have to go back and change my answers where I do this? :Crying:
@QHarr I feel you. I'm doing ByVal in 99% of my code just when it doesn't work I'm changing it to ByRef :-) Well, in my case I'm trying to never modify "outside" of the procedure so I pass ByVal, do something with it and return a "new thing".
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4022?src=pr&el=h1) Report > Merging [#4022](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4022?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/024eecde21aeca61da2cd9d66e2dfadfe0ed2be8?src=pr&el=desc) will **increase** coverage by `<.01%`. > The diff coverage is `100%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4022?src=pr&el=h1) Report > Merging [#4022](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4022?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/024eecde21aeca61da2cd9d66e2dfadfe0ed2be8?src=pr&el=desc) will **decrease** coverage by `<.01%`. > The diff coverage is `100%`.
In my install of Rubberduck, I'm not seeing labels in the Unit Test menu, making it really hard to understand how to use this feature (as a new user).
Here are my specs: Version 2.2.6711.17170 OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64 Host Product: Microsoft Office 2010 x86 Host Version: 14.0.7177.5000 Host Executable: EXCEL.EXE
And here is a screenshot to illustrate what I'm seeing.
> Thank you very much for reporting this. We are aware of this behavior and it has been documented in #4011. The resolution for it can be found in that issue, nobody has gotten to it yet. Closing as duplicate.
@QHarr the article is correct, objects aren't getting passed around, only references to objects, and ByRef/ByVal determines how that reference is passed
So if I pass a copy of a pointer to an array outside the procedure, then manipulate the array but don't return it, that's useless operations (instead of ByRef where the Array would be manipulated) but it won't harm the memory? I just have the certainty that the base array won't be manipulated?
I'm no C++ expert but I believe in some circumstance it's an error to pass objects by values.
I only say that because I recall the compiler getting all pissy if I create a procedure with OBJECT as a parameter, rather than a OBJECT* parameter.
also, I wouldn't call it "deep copy"; i've always understood a deep-copy to mean it copies all private and public fields. Normally, copying a object only copies the public fields --- that's shallow.
Please don't. That'd end up putting us back on digital stone age. Like it or not, way too much software are based on C/C++. I honestly doubt that the IL assembler and other low-level stuff of .NET stuff is written in any .NET language but C++.
@MathieuGuindon I've got a problem with translation... :-/ You wasn't here when I mentioned this. And I don't know what to do, tried that on 3 different machines, downloaded the standalone ResXManager again, which is just web executable thingie but the result is the same...
Is there a way to programmatically call a method on a predeclared id class? For example, if class Foo has method Bar something equivalent to Application.Run("Foo.Bar") ?
> RD version info: Version 2.2.6693.19208 OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64 Host Product: 2007 Microsoft Office system x86 Host Version: 12.0.6735.5000 Host Executable: MSACCESS.EXE
VBA IDE version info: Microsoft Visual Basic 6.5 Version 1057 VBA: Retail 6.5.1057 Forms3: 12.0.6723.500
I've been having a problem where the Access 2007 Navigation Pane does not update when new items are created in the database. I've narrowed the problem down to Rubberduck. To be c
but once it has ran, and a new call stack, you can debug again
hence, if you isolate the code rewriting in its own private function and only call when you actually need to update the select, then you can debug for 90% of time when you need it.
in OASIS (plugin for Access), there's options to run procedures as part of "build".
so you'd probably want to have your code generation stuff in a "build" module(s?) so that when you need to distribute a new version, it'll update the stuff.
Come to think of it, it wouldn't be too hard for RD to support this kind of functionality, esp. with the typelib api exposing the ability to run code.
So it can't be run as Administrator. Weirdly enough. But when I tried that on Laptop, it said "install" and then there was another Error windows telling me "JetBrains Annotations 11.1.0 has to be installed" so I googled and maybe for something like NuGet it can be downloaded.
Either way, I think, bye bye translations as work.... :-/ Or is there some other way?
ResX manager as standalone app - doesn't work. For a few days I could count on one hand fingers.
So I downloaded this: github.com/Vogel612/TranslationHelper and can't seem to figure out how to run it? (I've only double clicked on everything - gradlew.bat downloaded something and created .jar thingie that does nothing when I dbl click on it).
So on my Personal Computer I've finally installed Visual Studio... With Nuget. And because ResXManager needs annotations, I've found HERE: nuget.org/packages/JetBrains.Annotations/11.1.0 how to install them
Which I did after opening Nuget console and this happens...
Too many things I don't have experience with. VS for the first time, don't know what is Nuget, don"t know what are those annotations, don't know if I have what I need in VS, this gets to my head really fast... Just want to translate like a week ago :-/
A) Programming errors that are the programmer's fault (off-by-one, etc.) B) User error (invalid input) that the programmer needs to handle C) System error that aren't anyone's problem that the programmer needs to handle (often by not handling it)
A) The programmer writes code without errors and throws a variety of unit tests at it to make sure it works B) The programmer writes code to handle those errors in whatever way the specs specify, and throws a variety of tests against it to make sure it is implemented to spec C) Same as B, except you probably can't test it very easily (see the questions on SO about how to reliably crash certain devices)
For B), I would throw in: the programmer writes tests that produce any kind of illegal/malicious input the programmer can think of and makes sure nothing breaks down.
@IvenBach I use SSRS, Crystal was bought by SAP at one point, and no longer comes with Visual Studio (used to be the de-facto report authoring tool in VB6 times)
SSDT/BIDS can do pretty much everything Crystal does, and more
AFAIK anyway.. Sage has a few native Crystal Reports reports, but when they don't do what we need them to do then I get to redo them on SSRS
Intro
Related, related
I'm trying to come up with a neat, accurate way of timing VBA code, as I'm yet to find a method to do this in VBA directly (without plugins etc.)
The general idea was to create some Stopwatch class which could be initialised at the start of a test procedure, then various...
VBA Rubberducking
VBA Rubberducking