« first day (1746 days earlier)      last day (1434 days later) » 

12:01 AM
RELOAD!
[banane-io/PDB] 1 closed issue. 1 issue comment.
[bruglesco/FleetCommand] 14 commits. 1418 additions. 351 deletions.
[rubberduck-vba/Rubberduck] 1 closed issue. 8 issue comments.
[Zomis/minesweeper-flags-client] 5 commits. 1203 additions. 830 deletions.
Minesweeper: Games Played: 131, Bombs Used: 60, Moves Performed: 15594
 
12:34 AM
[rubberduck-vba/Rubberduck] build for commit 650d1199 on unknown branch: AppVeyor was unable to build non-mergeable pull request
BUILD FAILURE!
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4851?src=pr&el=h1) Report
> Merging [#4851](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4851?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/1e3e615cc1426c9817e1349ac6f27ee5678fca56?src=pr&el=desc) will **increase** coverage by `0.1%`.
> The diff coverage is `79.27%`.


```diff
@@ Coverage Diff @@
## next #4851 +/- ##
==========================
 
 
5 hours later…
5:23 AM
0
Q: Visual Basic For Applications - Array - Push | Pop | Shift | Unshift

learnAsWeGoI want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a sweet user interface. Fun! Also shout to bytecomb for providing example as to how to traverse the ar...

 
 
1 hour later…
 
4 hours later…
10:35 AM
@IvenBach holy carp when I started reading that answer I was pretty sure it was from Mathieu, but the writing style didn't quite match
 
@Vogel612 :+1: great answer Iven
 
 
1 hour later…
11:54 AM
Wow, quite the star show this weekend!
 
 
1 hour later…
1:11 PM
Questions on the library references:
1) Are they supposed to expand giving me some view into the OM?
2) Why are some greyed out and others in black?
No, I don't think I need both DAO and ADODB. I'll check into that, which makes this particular view quite helpful.
 
1:27 PM
Also of note:
 
> **Rubberduck version information**
Version 2.4.0.4613
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4810.1000
Host Executable: MSACCESS.EXE

**Description**
I noticed that I had `DAO (ACEDAO.DLL 12.0)` in my project but didn't think I needed it, so I used RD's `Add/Remove References` dialogue to remove it. When I hit `Apply`, my code immediately started executing, hit an error caused by an unknown reference, and the VBE hung with
 
@Duga Sometimes "I don't think I need that, I'll remove it and see what happens" is a great way to test things. Sometimes, not so much.
 
2:00 PM
@FreeMan FWIW not much point in not referencing DAO. Though you still can "late-bind", the Access OM can return a DAO object. Example: Application.CurrentDb returns a DAO.Database Also, I would venture to say it's more common to have Access projects using DAO exclusively OR both DAO and ADO (which I do) but exceedingly rare to use ADO exclusively
Mind, that bug thing you raised is definitely worrying. Simply removing any references should not cause code execution.
 
@this I agree on both counts. I'm not sure why I've got DAO in there, nor am I at all certain why it crashed on the line of code it did.
I am, however, attempting (somewhat unsuccessfully) to do something productive this morning, and tracking down why my code crashed there w/o the DAO reference, but works fine with it isn't high on the priority list for today...
Hi @MathieuGuindon, how's Seattle?
 
Bloody awesome!!! =)
 
good to hear. Glad you got there without issue.
 
2:49 PM
@Vogel612 hush. It’s not like I have aspirations to dethrone our benevolent dictator.
3
 
3:45 PM
@mansellan I've had superb examples at the pond to learn from.
 
@IvenBach earlier in the chat, you were talkn to a dude
 
Mugs certainly warmer this week.
 
and i was like... why is he talkin to himself
till i looked at the name, hte avatar looked about as similar as mat's and that whole red white thing
 
I talk to myself when my code doesn't work. Mostly "Why are you not :think: .... should work :think-more: nope. That's why it's incorrect."
Added benefit of being low rep is with 2 questions answered I added 10% to my interweb rep points.
 
4:01 PM
it was bruglesco
 
 
1 hour later…
5:12 PM
0
Q: Vba - Loop whose endpoint (?) change during the loop

a1a1a1a1a1I have a loop which insert rows on specific cases. The loop goes through ~2000 rows and insert about 500. Due to the inserted rows it doesn't loop the full range I want. I have solved that problem by counting the number of row I will insert with a first loop and then looping up to LastRow + Coun...

 
5:45 PM
@Duga WTF?
There's nothing on that code path that would cause VBA code to execute unless removing a reference in the VBE triggered an event somehow.
@FreeMan References won't expand out in the CE, but eventually the plan is to let you open them in the (Rubberduck) OB via the context menu. Greyed out references are ones where no references were found, although they won't undim until after the parse is finished.
 
6:08 PM
ok... just had a bit of a wtf moment
user is using an access application, fresh download to their computer, they run it and they get kicked to the VBE
but, no error message or anything, click continue, it runs fine
you do the same action again, and it doesnt trigger
it was like there was a breakpoint enabled or something
cept there wasnt
 
6:33 PM
Duck check: With git bash you can do ls -la where ls = list the folder and the flags L = list long format A = include all files, hidden files too.
When it displays the files with the attributes is there any location where I can read about what the attributes are?
 
@Comintern seems to be an issue with grey/black highlighting then:
@IvenBach Will this work: en.wikipedia.org/wiki/File_attribute
 
That along with en.wikipedia.org/wiki/Ls#Sample_usage should get me to comprehenderize what I wanted.
Thanks for that.
 
yellcome!
Just remember - there's a difference between ls -la and ls -LA. bash is from the land of *nix and case matters! (Prolly even in the Windoze version.)
 
Did not know that.
 
6:41 PM
@IvenBach Yeah, try accessing a *nix server from your Win machine where your server has \usr\IvenBach and \usr\ivenbach. Windows will see them as one directory, but they are very definitely two different directories on the server. You'll create all kinds of chaos if you're not super careful.
 
It's a bit silly that git-bash doesn't have the man pages available via its busybox.
 
@Comintern TYVM.
 
your best bet when doing that is to use a CMD prompt, though even there, Win is likely to conflate the two directories. At least you'd be able to cd z:\usr\IvenBach and be in the correct one, even if Win won't show you the difference. (I think test at your own peril)
 
No concern for me as everything is Windows.
:+1: for the explicit call out.
 
@FreeMan It won't let you do that if the underlying file system doesn't support it.
$ mkdir Testing
$ mkdir testing
mkdir: cannot create directory ‘testing’: File exists
 
6:52 PM
@Comintern running arch?
 
No, Mint - Arch just has better online docs.
 
that's odd. I've tripped myself up a couple of times with different cased directories when creating one from Linux and accidentally creating another (on the same server, in the same directory) from Windows
don't remember what the underlying OS is. It's a custom distro running my file server
 
That sounds more like a Windows problem than a Linux one.
 
thoughts on the Library References?
@Comintern well, of course!
 
@FreeMan I'm completely stumped. Only thing that I can think of is that there was a running VBA process, and forcing a recompile triggered it to discard an object or something.
FWIW, that's pretty much all the VBE OM - the references dialog just calls References.Remove there.
What's in your WebHelpers component at line 2947? There's a parse error in the log for that function:
ParseType: Main parse;Rubberduck.Parsing.VBA.Parsing.ParsingExceptions.MainParseSyntaxErrorException: mismatched input 'End Function' expecting {ABS, ANY, ARRAY, CBOOL, CBYTE, CCUR, CDATE, CDBL, CDEC, CINT, CLNG, CLNGLNG, CLNGPTR, CSNG, CSTR, CURRENCY, CVAR, CVERR, DEBUG, DOEVENTS, FIX, INPUTB, INT, LBOUND, LEN, LENB, LONGLONG, LONGPTR, MIDB, PSET, SGN, UBOUND, ACCESS, ADDRESSOF, ALIAS, AND, ATTRIBUTE, APPEND, AS, BEGINPROPERTY, BEGIN, BINARY, BOOLEAN, BYVAL, BYREF, BYTE, CLASS, CLOSE, DATABASE, DATE, DOUBLE, ELSE, ELSEIF, END_IF, ENDPROPERTY, END, EQV, ERROR, FALSE, GET, IMP, IN, INPUT, IS
 
7:07 PM
''
' Parse ISO 8601 date string to local date
'
' @method ParseIso
' @param {Date} utc_IsoString
' @return {Date} Local date
' @throws 10013 - ISO 8601 parsing error
''
Public Function ParseIso(utc_IsoString As String) As Date
  On Error GoTo utc_ErrorHandling

  Dim utc_Parts() As String
  Dim utc_DateParts() As String
  Dim utc_TimeParts() As String
  Dim utc_OffsetIndex As Long
  Dim utc_HasOffset As Boolean
  Dim utc_NegativeOffset As Boolean
  Dim utc_OffsetParts() As String
  Dim utc_Offset As Date
Line 2947 is the End Function line.
borrowed that from:
''
' WebHelpers v4.1.4
' (c) Tim Hall - github.com/VBA-tools/VBA-Web
haven't actually used any of it, so I could reasonably discard the module.
 
I'm mainly curious why the parser throws on it.
 
beats me...
@FreeMan @Comintern that's the one I was specifically asking about, though...
 
Yeah, I'm checking the log on that one. I'm assuming the reference counts are correct on the RD toolbar?
This seems to think you were in break mode:
2019-03-18 09:16:18.0913;ERROR-2.4.0.4613;Rubberduck.UI.AddRemoveReferences.AddRemoveReferencesViewModel;System.Runtime.InteropServices.COMException (0x800ADF09): Can't execute code in break mode
   at Microsoft.Vbe.Interop._References.Remove(Reference Reference)
   at Rubberduck.AddRemoveReferences.ReferenceReconciler.ReconcileReferences(IAddRemoveReferencesModel model, List`1 allReferences) in C:\projects\rubberduck\Rubberduck.Core\AddRemoveReferences\ReferenceReconciler.cs:line 75
   at Rubberduck.UI.AddRemoveReferences.AddRemoveReferencesViewModel.ExecuteApplyCommand(Object parameter) i
Well crap - apparently I missed a case with the last parser update. This is failing:
If utc_NegativeOffset Then: utc_Offset = -utc_Offset
Oh wait, I'm not even with next at work...
 
I'm pretty sure I wasn't executing any code/in break mode when I removed the reference.
 
VBE seems to think it was. I wonder if it's related to that other bizarro Access form thing.
 
7:23 PM
Just for giggles, I'll try it again tomorrow. Gotta run now, though - the car needs some new tires. (now that winter's basically over.)
 
I should submit a PR to remove all the superfluous statement separators in VBA-Web. Tim should know better than that crap.
 
8:01 PM
@Comintern then the question to @FreeMan ought be - was any Access form opened in normal view when using the reference dialogs
IME, it should not run code just because it's. There is stuff like Activate or Got/Lost Focus events but I don't think those run just by VBIDE interactions.
 
@this It is running class code apparently (from the screenshot). I was thinking that something might have been holding a WithEvents reference.
I can't tell from the log if it was the first reference it tried to remove that threw or a subsequent one.
 
hmm. Can't recall off the cuff but isn't References event exposed?
Yep, just confirmed. Access.References exposes events for adding/removing references. So another question to @FreeMan would be whether he's listening to the Access.References events.
 
Access.References? Is that different than the VBIDE.ReferencesEvents?
 
I don't think we use ReferenceEvents, do we? I think that's VB6 thing.
Access.Reference is basically a wrapped VBIDE.Reference in Access' OM
Ditto for References.
 
WTF? MS is letting people tag ads on docs now?
> UtterAccess is the premier Microsoft Access wiki and help forum. Click here to join.
I thought we did listen to ReferenceEvents (for the benefit of the parser). Could be wrong though.
 
8:13 PM
Been a thing for a while - MS is trying to get various user communities to contribute to their help documentation.
I just checked, and it's actually _dispReferenceEvents which isn't the same thing, but still amounts to the same thing.
Because, Microsoft.
 
> Rubberduck is the premier VBE add-in. Click here to install.
 
Heck, yeah. We should start a marketing campaign!
:-p
 
> Usage sample provided by Rubberduck VBA contributors. Written by the VBExperts.
 
but then again, even if he was listening to the event, that should be after the fact, right?
 
Probably during. The code isn't horribly sophisticated ATM.
 
8:23 PM
@Comintern help me understand where does these tag come from? Source link?
 
@PeterMTaylor You can get an anchor on GH by clicking on the line number.
(or you can build your own by tacking #L42 on the end, where 42 is the line of code).
 
@comintern just wanted to check you'd seen / can access my dropbox link from earlier
 
@mansellan Yep. Pulled it this morning on my way out the door for work. I was going to start poking at it when I got home.
 
ok cool, not shared anything on dropbox before, just wanted to check I did it right
 
Worked perfectly.
 
8:34 PM
:)
 
posted on March 18, 2019 by CommitStrip

Today we’re welcoming back Oracle, who’re organising their Code Explore conference in Paris! It’s a small (free!) tech conference, open to all, for an afternoon. There’s Kubernetes, bots, serverless and all that, mostly (but not only) focusing on Oracle technologies. It’s the perfect opportunity to get yourself up to date on the latest new technologies, and the venue is really neat (the Livepoi

 
@Feeds LOL.
 
9:29 PM
Ugh, in which PR and with which intention were changes introduced into the IntroduceFieldRefactoring and the ExtractInterfaceRefactoring?
I have no idea how to fix my merge conficts.
 
@M.Doerner Wasn't me, but git blame can help.
 
WTF, apparently I have conflicts with my last PR whose commits are also in the current one.
 
LOL.
Rebase?
 
Nah, I just took the new ones.
 
feel like i'm missing something - all I get is "blabla" and no listing of issues that it can find?
or is it saying that the VBA itself is an issue?
 
that feeling when you sneeze and it feels like you are snorting pool water...
 
@this they're considering embedding RD (JKP told me so); I told JKP RD is GPL, not MIT; clarified concerns about whether they'd be open-sourcing the mods, and properly attributing the original work.
BTW are you @ summit?
I'm in building 92 =)
 
yep to both
@MathieuGuindon That's very interesting! IDK how much of RD inspections are a part of "risk assessments" Interested to see where it goes.
 
@MathieuGuindon who's JKP?
nvm... Jan Karel Pieterse
 
10:07 PM
Any duck here able to rubberduck with me regarding WPF? Adding a Name or x:Name attribute causes the build to fail.
 
soo... what's the build error?
 
> 'Could not load file or assembly 'file:///C:\Users\ivenbach\source\repos\SaveTheHumans\SaveTheHumans\obj\Debug\Sa‌​‌​veTheHumans.exe'
 
so. ... when you remove the Name it works again?
 
Correct.
 
wat
 
10:10 PM
If the Name attribute is not included it builds just fine.
Adding the Name attribute allows me to build. Caveat being that if I clean then build it barfs.
 
and x:Name just instant fails?
does it matter which element you put it on?
 
So far it's whenever I attempt to add x:Name or Name on any control within the window.
 
are you sure that specific error is the root cause? Check the build log for the first failure
 
> C:\Users\ivenbach\source\repos\SaveTheHumans\SaveTheHumans\MainWindow.xaml(11,21‌​): error MC2000: Unknown build error, 'Could not load file or assembly 'file:///C:\Users\ivenbach\source\repos\SaveTheHumans\SaveTheHumans\obj\Debug\Sa‌​veTheHumans.exe' or one of its dependencies. The system cannot find the file specified. Line 11 Position 21.'
Same message as the output window.
Is there another location I should look for the build log?
 
there is the Build window in VS...
 
10:22 PM
Removing xmlns:local="clr-namespace:SaveTheHumans" allows it to build but I don't know why.
 
Heh, just watching this weeks "Last Week Tonight"... I find John Oliver extremely funny, but wow that dude hates Brexit :-)
 
10:36 PM
@IvenBach SaveTheHumans?
 
@mansellan Looks like the 64-bit edit confused the linker.
 
@mansellan Head First C# book. Trying to fill in the gaps of my knowledge.
 
@Comintern hmm ok. I'm hoping that the code is actually 64-bit, but perhaps the COFF header(s) are malformed due to the age of the ODE code. The COFF headers can be fixed, the binary code can't. Is there a chance?
 
It's failing in ntdll on LdrpInitializeProcess, but I can't tell if it's a linking problem or not - the last error that was set was STATUS_OBJECT_NAME_NOT_FOUND.
 
I'm guessing (based on not very much knowledge) that if the asm addresses are 8 byte, there's a (slim?) chance?
 
10:42 PM
I doubt that the COFF headers have changed for a long time.
 
@Comintern no, but possibly the compiler is emitting hard-coded flags which have since been updated to specify 64-bit options?
 
It looks like it might have something to do with the base addressing. It stops here:
00007FFD5579C92C                                | E8 FFE4FCFF              | call <ntdll.ZwQueryInformationThread>                    |
00007FFD5579C931                                | 85C0                     | test eax,eax                                             |
00007FFD5579C933                                | 78 0A                    | js ntdll.7FFD5579C93F                                    |
00007FFD5579C935                                | 807C24 40 00             | cmp byte ptr ss:[rsp+40],0                               |
 
The other possibility is that the Office VBA 64 compiler is still perfectly capable of creating 32-bit output, and will only do so for standalone projects. Which would suck.
 
The failing offset is 00007FFD5579C933
 
so... just have to find the right base address?
 
10:45 PM
Well, looking at it, the base address seems right.
 
could it be that the offsets are borked because this in, in fact, 32-bit code?
 
At least the functions appear to line up with the symbols AFAICT.
 
@Comintern on link attempt 2?
 
I may need to actually try to load it from a VBA project instead of trying to just load the .dll in a dummy process.
Yeah, this is link attempt 2.
 
got that base address from MSDN, as the expected for 64-bit COM DLLs
@Comintern resolves to learn how to read stuff at this level...
 
10:52 PM
This is a good starting place: x64dbg.com/#start
 
actually, I had a thought - I could try linking the original (non-hex-edited) 2010 output. If that produces a fully-functional COM library, that would confirm the code as 32-bit, and blow this idea out of the water.
 
It would at least narrow down whether or not the linker is missing something.
 
11:19 PM
Well... mixed results. OleWoo likes it, but trying to ref it in VBA and call a method yields 'ActiveX cannot create component' That may just be because the user form ended up not being publically creatable though.
It's certainly looking more like 32-bit than 64-bit to me at this point :-(
 
@Vogel612 Best I could figure is social.msdn.microsoft.com/Forums/vstudio/en-US/… lead me to try and comment out xmlns:local="clr-namespace:SaveTheHumans" and that fixes it. Still don't fully understand why.
 
If I had to guess, I'd say that when they updated for VBA7, they just added the ability to compile to 64-bit, but kept all the 32-bit targetting too. The latter to be used a) in 32-bit office and b) in 64-bit office when building standalone projects (probably by accident / omission)
 
@IvenBach that namespace creates a dependency to the assembly.
but apparently the WPF build process doesn't understand that it's building the assembly it's depending on....
which means the build process fails..
 
That's part of the code that was generated when the Window was first created.
 
at least that's what I would infer from the information given ...
 
11:28 PM
It's dependent on itself, the assembly that it's trying to build. So you're saying it's a chicken duck or the egg problem?
 
I'd at least stab in that direction, yes...
you are using the new csproj format?
 
This is in the C# Head First book. Not actually dealing with RD.
But I'm trying to understand this error because I think it may deal with RD indirectly.
 
yea, but you must be using some project when building right?
which reminds me: BBIAW updating #drunkvs
 
Only the single project that contains the work.
 
and that project is using which format?
I'm basically asking whether the root xml element contains an Sdk attribute
 
11:40 PM
It's a System.Windows.Window class. Unless I'm not understanding.
 
you're not, but that's okay :)
right click the project in the solution explorer
it should have the option to "edit csproj"
 
@Vogel612 You're just the person I was hoping to see.
 
if that option is greyed out you're using the old csproj format. if it's available you're using the new one
@Hosch250 that's either something great or something terrible. How can I help?
 
I'm looking to include a MIT dependency in a closed-source software. 1) that's legal, right?
And 2) what would be adequate for including the license?
 
yes
 
11:42 PM
This is from NuGet.
 
MIT license must only be put with the source code IIRC
 
OK.
So, I can include the DLL without doing anything?
That's cool.
 
yeap
read the License just be sure, this advice is from memory
 
Just looking for a markdown parser/renderer so I can render documentation pages.
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
 
@Vogel612 ^ Don't have that option.
 
11:44 PM
okay you're using the old format then :)
which means the build shouldn't do weird stuff...
 
Whatever format was auto-generated.
 
@Hosch250 IIUC MIT is pretty much, use this as you like, but there absolutely no warranty. use at your own risk, and you must include the license.
 
That's my impression.
The hard part was including the license, since I just have a DLL.
So it's not like I can just stick it somewhere with the source code.
 
my reading (not a lawyer) is that top of source is adequate.
oh wait, its not your dll :-)
 
Nope.
I'm referencing it from NuGet.
 

« first day (1746 days earlier)      last day (1434 days later) »