2018-05-23 09:33:52.4921;FATAL-;Rubberduck._Extension;Startup sequence threw an unexpected exception.;System.ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at Rubberduck.VBEditor.Events.VBEEvents.RegisterComponents(IVBProject project) in C:\projects\rubberduck\Rubberduck.VBEEditor\Events\VBEEvents.cs:line 83 at Rubberduck.VBEditor.Events.VBEEvents..ctor(IVBE vbe) in C:\projects\rubberduck\Rubberduck.VBEEditor\Ev…
> Hi, I just installed rubberduck and tried to run it on an empty project. When refreshing for the first time, I get the following message: Unable to compile for parsing
the following project(s) cannot be compiled, which will most likely result in parser errors. Continue anyway?
VBAProject
this is the logfile generated: [RubberduckLog.txt](https://github.com/rubberduck-vba/Rubberduck/files/2030187/RubberduckLog.txt)
I'm very new to VBA and wonder if someone can help with this.
I want to select a table in Excel and then run a macro that formats the table of my choice. The macro should also Add a title to the table (Above the first selected row) and should also leave a footer to the table (Below the last sele...
> The problem seems to be that member access resolution generally fails for members of parameters. More precisely, the `MemberAccessDefaultBinding` does not take into consideration that a `lExpression` with classification `Variable` might have the `DeclarationType` `Patameter`. I will see whether that really is the cause when I am back home tonight.
> The problem seems to be that member access resolution generally fails for members of parameters. More precisely, the `MemberAccessDefaultBinding` does not take into consideration that a `lExpression` with classification `Variable` might have the `DeclarationType` `Parameter`. I will see whether that really is the cause when I am back home tonight.
> Is that really the complete logfile? Can you reproduce the error? If yes, could you please set the log-level to TRACE in the settings and upload that logfile? Thanks!
``` 2018-05-23 10:10:38.3421;ERROR-2.2.6716.24410;Rubberduck.Parsing.VBA.ParseCoordinator;Unexpected exception thrown in parsing run. (thread 14).;System.Runtime.InteropServices.COMException (0x80029C4A): Erreur lors du chargement de la bibliothèque/DLL du type. (Exception de HRESULT : 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
> I'm going to go out on a limb and say it _is_ inconsistent. After noting the conversation, and especially the comment about the MCVE not having the Variant parameter, I made this:
```VBA Public Sub foo(ByVal myRange As Range, ByVal value As Variant) myRange.value = "Bar" End Sub ```
Oh I have to proudly show off my work :D After 3 days and 30 hours (I know, I'm really slow) I have the almost final product :) (well, like 1/20 part of my current project, but... read bellow)
The trick, why it didn't take me only a few hours of coding is that I don't have anywhere anything hardcoded. :-) The functions I've written should work on other forms with any number of controls, tabs and so on. So the next, almost the same window, would be done in like 5 minutes :-)
Proud of myself :D Don't now where to boast so sorry about that :D
@FreeMan I've got a worksheet with hundreds of rows and dec.. dec... 10..20..30 (don't know to word) of columns that have all the data about "project" and my task is to create code background for existing GUI forms (we have like 15 of them) which will manipulate those data. :)
Better would be if I know what "Implementations" are. As Mat recommended a few months ago. But I don't :-D So... Doing it the "function way", sometimes "class way" :D
Right now I just CAN'T FIGURE OUT (sorry, I pushed shift for a longer duration...) the way that if I have something selected in my Listbox and I click on a blank place on that listbox (under the text), it would fire an event.... (to deselect the item)
Code is written for a human maintainer to read, understand, follow, debug, modify, extend, etc.
Without any level of abstraction, code is a boring, excruciatingly mind-numbing series of executable statements that are invariably redundant, inefficient, and annoyingly bug-prone.
the owner of the company asked for a daily dashboard of sales figures for all child companies and various production figures. the data is coming from a MySQL database, two SQL Server instances in two distinct AD domains, and an AS/400 file system with a spiderweb consisting of well over 2000 data files, most redundant, none documented.
Out of the blue I got a text from my mentor at NASA. Seems they got funding and he wants to bring me back as a consultant to complete my project from when I interned.
@IvenBach Remote is easy enough if you A) have a dedicated workspace to work in, and B) don't over-work (stick to 8 hr or so, with limited extensions for emergencies).
I used to be a freelance but sucked at it which is why I work for a company. Let my boss focus on the sales (which he is skilled at) so I can focus on programming.
I'd find out what they mean by consulting. They may be expecting you to work full-time for a short period
FWIW, if this is what you want to do for a living, it usually might be worth the risk. I don't think I would e working at a consulting firm had I not been a freelancer (and failed)
> Would you happen to have any `<MISSING>` references? Does Debug/Compile succeed?
The "cannot be compiled" message is just a warning; you can disable it by un-ticking the "compile before parse" checkbox in the *general settings* tab of the settings dialog. Working with compilable code was always an assumption in Rubberduck, only recently we've been having the ability to instruct the VBE to attempt a compilation and report back to us before launching a parse task.
I'd propose this wording (under "Readability & Maintainability", and "suggestion" or "hint" level):
> **Bitwise operation uses arithmetic operator** > While mathematically equivalent, the arithmetic addition `+` and bitwise `Or` operators don't convey the same *semantics*: in the case of bitwise operations on enum members, using a bitwise operator better conveys the actual operation being executed.
@Mathieu Guindon, Thank you for your elaborate answer. From your answer and en.wikipedia.org/wiki/Abstraction_(computer_science) I currently understand that the size of the compiled code is meaningless because the difference in level of abstraction renders the effects of for example refactoring the subroutine code as practically untraceable. Thank you for the pointers to tools that allow me to work on the XY-problem more effectively! I am a great fan of the work put into Rubberduck, and I will be more persistent in applying it. — a.t.11 mins ago
savedSouls++;
@a.t. You'll probably want to keep an eye out on the progress of the rewriting of the Extract Method refactoring tool ;-) — Mathieu Guindon1 min ago
> @Hosch250 Correct... and this means the inspection needs to evaluate the type of the operands around + operators, which is a bit more involved than the OP assumed.
> Actually, that's not the job of the inspection at all - we can consider this inspection blocked until a "compilation pass" is implemented in the parser/resolver engine, to annotate expressions with their type.
> Actually, that's not the job of the inspection at all - we can consider this inspection blocked until a "compilation pass" is implemented in the parser/resolver engine, to annotate expressions with their type.
Maybe this has been obvious to the two of you, but it just hit me. The inspection is legit - I'm passing `ByVal SummaryRange As Range`, then assigning to `SummaryRange.Value`, so I am assigning to a parameter passed by value.
However, the parameter is an object, so passing the pointer to t
> @daFreeMan no, you're not assigning the SummaryRange reference, which is what the inspection means to be flagging. You're assigning a member of SummaryRange, i.e. SummaryRange.Value, which shouldn't trigger the inspection in any way. This is absolutely a false positive.
LOL... The blur box on a product video was put in a static position, even though it was zoomed out when they initially showed the product key. Advertising at its finest.
Seems you misunderstand the purpose of a form. What's the query supposed to do if the form isn't loaded? Queries don't care about forms, but they can take parameters. Look into parameterizing your queries, not for ways to hack up a coupling between a query and some form. The parameter value can come from a form, but the query should be fundamentally and blissfully unaware of where the parameter value came from. — Mathieu Guindon1 min ago
I kinda hate Access
If DateValue(LastDateRead) < DateValue(Format(DateSerial(YearA + 1, 1, 1))) Then
> Help I don't know why VBA can't understand my dates
I personally think it's an anti-pattern to write a query that depends on form's control. It is legal but it's awful and impossible to test. will write a response later.
^ feels like "let's stuff it with a bunch of date functions I vaguely understand and hope for the best"
Please try to come up with a Minimal, Complete, and Verifiable example. "The issue I am running into is that the dates I project take the day value and set it as the year and take the year value and set it as the day" - I've read this thrice over and still can't understand what it means. Treat dates as dates, dates are numbers, not strings. Where are the declarations / Dim statements for all these dates? — Mathieu Guindon3 mins ago
FWIW, i'd avoid "dates are numbers" -- technically true but it should not be material and they should not be encouraged to violate the date's abstraction, IMO.
> Is there anything else in the method that could trigger the inspection? I cannot reproduce the issue with the snippet provided, i.e. the following code does not cause an inspection result for me, neither in a standard module nor in a class module.
```vba Public Sub SetSummaryCell(ByVal SummaryRange As Range, ByVal value As Variant, ByVal FormatFlag As String)
SummaryRange.value = CStr(value) 'other stuff End Sub ```
If you don’t mind me asking folks, what’s RD position with this the new European privacy data laws (GDPR) due on May 25th. just wanting to make sure I understand where we sit. I know we are protected and have oversight under Stack Exchange for our chat, Github complies for our codebase, that leaves Wordpress blogs moving to your own domain and your twitter under twitter inc which had updated their policies. Is anything left out?
VBA Rubberducking
VBA Rubberducking