RELOAD!

[retailcoder/Rubberduck] 1 opened issue. 1 issue comment.

[Zomis/Calculator] 18 commits.

[Zomis/ZonesAndCards] 3 commits.

@Duga I missed that! :)

@Simon's on a roll today!

(brewing coffee)

> 132 downloads

At this rate v1.22 x86 will hit 100 downloads by the end of the week!

My director was giving a workshop on "Individual Development Plans" today. When asked for a recent accomplishment, I replied.

> The latest release of my open source project has over 100 downloads.

@RubberDuck nice!

you should have specified, 100 downloads in 3 weeks

Didn't wanna gloat. Just needed to make a point.

:)

[retailcoder/Rubberduck] retailcoder pushed 12 commits to next

[retailcoder/Rubberduck] retailcoder pushed commit c7e42cc3 to next

> Merge branch 'next' of github.com/retailcoder/Rubberduck

[retailcoder/Rubberduck] retailcoder pushed 23 commits to GrammarIsFun

I'll be working on the grammar issues in the GrammarIsFun branch. Tomorrow.

I think that rubberduck was planning on rewriting the grammar from scratch.

Also don't hold back fixes from the installer of they're important. I've got a skeleton for an installer script but I'm not sure how much Polish it needs

@RubberDuck About time someone gave you some competition!

@Rossco it will be a while before I get around to that.

> Indeed, I'm running 64-bit Office 2010 on Win7 x64, ...my debug build works fine, but I'll make a custom Rubberduck mug and send it to whoever sends us a pull request that gets the darn x64 installer to work out of the box!

Now I want mugs.

@RubberDuck My wife will kill me.. but I almost have the artwork all adapted :)

lol

I modified my ProgressIndicator to have a PredeclaredId and added some Friend properties... should I edit my post or keep it for a selfie?

Your call. I looked at the code, but haven't had time to think about it.

Getting ready for #JDAFocus

I won't udpate it; having issues with Application.Run to execute a standard module procedure, since the ProgressIndicator is in another VBProject it's not finding the "DoWork" procedure...

..but it works fine with a class instance

ah, got it to work... wow that's dumb

Public Sub DoSomething()
    With ProgressIndicator.Create("'" & Me.FullName & "'!" & "DoWork")
        .Execute
    End With
End Sub

^^ in ThisWorkbook

ok I'm updating it.

there. I included the macro-qualifying code inside the ProgressIndicator class itself, so I can wire up a macro like this:

Public Sub DoSomething()
    With ProgressIndicator.Create("DoWork")
        .Execute
    End With
End Sub

and I've just adapted my FiscalCalendarScriptGenerator to use it instead of updating the status bar, in seconds!

Public Sub GenerateCalendarScript()
    With System.ProgressIndicator.Create("DoWork", Me)
        .Execute
    End With
End Sub

works wonders!

SNAP is rubbing off?

Nothing like the smell of fresh coffee SNAP bugs in the morning ;D

That things makes my bugs look like features.

Looks like we're having an epidemy of Fridayitis here today. About half my team called in sick.

If only i could have. I hate data entry.

As you quackers are some of the main @Duga users, any thoughts on this?

github.com/Zomis/Duga/issues/79

:+1:

github.com/Zomis/Duga/issues/79#issuecomment-95967471

Thanks quackers!

[retailcoder/Rubberduck] AjayKMehta starred us

You're welcome @Simon, but it's us who should be thanking you. =;)-

^^ well, we are ;)

I can not comprehend how people do data entry for a living.

I'm ready to gouge my eyeballs out over here.

On the bright side, my MVC in VBA works beatifully.

Can one even use IF ELSE or SELECT CASE in Access?

Or must I use IIF?

@cheezsteak IFF

I think there is a Select, but it doesn't act like you think it would

Can't remember off the top of my head.

@cheezsteak There's a CASE-like statement called SWITCH

@RubberDuck did you mean IIF? because IFF is not defined.

@sᴉɔuɐɹɥԀ Is that something that I must write in the SQL or can I do that from the design pane?

SWITCH(
  [Correct_Product_ID]="CE Other","98"
, [Correct_Product_ID]="Notebook","	05"
, [Correct_Product_ID]="Netbook","	02661"
, [Correct_Product_ID]="Desktop","	01T"
)

SWITCH(expression1, value1, expression2, value2)

I don't think you can do it with the design pane. Could be wrong.

@cheezsteak ummm.... yeah. That.

@sᴉɔuɐɹɥԀ and...ummm...... that too.

@sᴉɔuɐɹɥԀ I think you can type into the field box like IIF. More important though, I take it is not short circuit? The false clause is evaluated even if the statement is true? Just like the IIF function in VBA?

^^ No idea. Ducky might know

@cheezsteak AFAIK, yeah

Yeah. I think it's equivalent.

@ticker U Y DAO?

[retailcoder/Rubberduck] ckuhn203 opened issue #411: Log Parsing Errors

> It would greatly help if we had a log of parse errors when investigating Code Inspection false positives. We can create a custom error listener that logs lexer and parser errors to a file for review. As we're inspecting source code, that could be proprietary, I think we should conditionally compile this out of any release versions and only use it internally. There's an [example of a custom listener here][1]. It actually ensures exceptions are thrown, instead of swallowed, but should be a...

nice example of how we could log in the places where it throws exceptions. [1]:github.com/ckuhn203/Antlr4Calculator/blob/master/Calculator/…

[retailcoder/Rubberduck] ckuhn203 added label enhancement to issue #411: Log Parsing Errors

[retailcoder/Rubberduck] ckuhn203 added label code-parsing to issue #411: Log Parsing Errors

[retailcoder/Rubberduck] ckuhn203 added label vba-grammar to issue #411: Log Parsing Errors

[retailcoder/Rubberduck] ShearOfDoom starred us

@Duga Ooh nice, 40 stars!!