« first day (2244 days earlier)      last day (936 days later) » 

12:01 AM
RELOAD!
[rubberduck-vba/Rubberduck] 2 issue comments.
[Minesweeper] Games Played: 76, Bombs Used: 59, Moves Performed: 9466, New Users: 9
 
12:31 AM
 
 
2 hours later…
2:16 AM
wow this is stupidly harder than anticipated
 
 
1 hour later…
3:38 AM
and fixed
deploying
completed
 
I'm not understand what I'm looking at here...Is code/content being added to Class1?
 
> Content updater app has been deployed, merging.
[rubberduck-vba/Rubberduck] retailcoder pushed 26 commits to next (only showing some of them below)
[rubberduck-vba/Rubberduck] retailcoder pushed commit d9c28347 to next: merge with conflicts
[rubberduck-vba/Rubberduck] retailcoder pushed commit ca9f3e19 to next: Fixes warning AC0180
[rubberduck-vba/Rubberduck] retailcoder pushed commit 16b9b371 to next: fixes broken namespace refs
[rubberduck-vba/Rubberduck] retailcoder pushed commit 74c9d4c1 to next: undo ca9f3e192...
[rubberduck-vba/Rubberduck] retailcoder pushed commit 35a25200 to next: removed code accidentally committed
[rubberduck-vba/Rubberduck] retailcoder pushed commit 409f5c08 to next: adjusted analyzer test, added missing cases
[rubberduck-vba/Rubberduck] retailcoder pushed commit 735e02a8 to next: reworded summary
[rubberduck-vba/Rubberduck] retailcoder pushed commit c1c1b919 to next: made <module> a child of <before> and <after> tags for annotations; allows having new module type in the <after> example.
 
@BZngr example code for the PredeclaredId annotation
 
[rubberduck-vba/Rubberduck] retailcoder pushed commit 4bde4a8f to next: added missing single quotes
Merge pull request #5479 from retailcoder/next

Adding xmldocs for all annotations
 
the [new] markers will disappear when the xmldoc assets are updated from the [master] branch
 
3:50 AM
So it is showing that if you use the '@PreDeclaredIds, it will generate Attribute VB_PredeclaredId = True in the module export file?
 
> @PredeclaredId annotation, indicates the presence of VB_Predeclared module attribute value (True) that defines a default instance for the class, named after that class. Use the quick-fixes to "Rubberduck Opportunities" code inspections to synchronize annotations and attributes.
 
The current state or the intent that VB_Predeclared = True ?
If intent, then quick-fix is used to synchronize them.
(?)
 
yes, that's what the page says
> Class1 (code pane)
> Class1 (synchronized, hidden attributes shown)
the idea is to show what we use a given attribute annotation for, on that annotation's page
the SynchronizeAttributes quickfix page has several examples, but not one for every annotation - and shouldn't have to need one for each either
 
Hmmm...a little slow tonight I guess. I'll have to play around with it to understand it better.
 
actually, there's the AdjustAttributeValues quickfix, AddMissingAttribute quickfix, RemoveAttribute quickfix, ...but no SynchronizeAttributes quickfix. ..and I need to double-check where I think I saw a page with 4 examples, can't find it atm
anyway, the xmldocs parse into RDDB records now :)
once the build completes, the [edit this page] links that currently go 404 should start working now, for all inspections, annotations, and quickfix pages
 
4:03 AM
Nice!! That will be really great.
 
yep, the links work!
 
[rubberduck-vba/Rubberduck] build for commit a16e40df on next: AppVeyor build succeeded
 
each namespace involved has a README.md file now
 
I'm poking around the site now...it's Awesome!!
 
4:08 AM
:D
> The "edit this page" link on each page generated from xml-doc content in this namespace, links to https://github.com/rubberduck-vba/Rubberduck/edit/next/{namespace}/{quickfix-name}.cs; it is imperative that the files' folder location corresponds to their namespace, lest we generate broken links on the website.

The content generated from xml-doc in this namespace (and any concrete inspections in a namespace under it) is accessible at https://rubberduckvba.com/quickfixes/details/{quickfix-name}.
^ the namespace readme for quickfixes
oh crap, pasta sighted
 
pasta?
 
copy/pasted from the inspections readme lol
 
ah :)
 
> The "edit this page" link on each page generated from xml-doc content in this namespace, links to https://github.com/rubberduck-vba/Rubberduck/edit/next/{namespace}/{inspection-name}.cs; it is imperative that the files' folder location corresponds to their namespace, lest we generate broken links on the website.

The content generated from xml-doc in this namespace (and any concrete inspections in a namespace under it) is accessible at https://rubberduckvba.com/inspections/details/{inspection-name}.
 
4:32 AM
uh-oh
ugh either the [new] tab on the index page (inspections in particular) is drunk, or I messed something up in RDDB
 
hm, the search query is blowing up
 
5:17 AM
[rubberduck-vba/Rubberduck] web-flow pushed commit 60055fcd to next: Fixed invalid xml
 
Inspection -> QuickFix links work now
search is fixed on my local, but I have other changes WIP.. deploy will have to wait a bit
 
6:37 AM
0
Q: Comparing excel spreadsheets

Magda SI am just started working with VBA dictionary and I would like to compare some excell sheets. I have reading a lot of VBA dictionary in the internet and my doubt is:My Sheet1 has 1200 rows and Sheet2 has 850 rows and both has the the quantity of columns. When comparing to sheets with VBA dictiona...

 
> This PR adds a simple button linking to the /inspections website page that opens the details page for the selected inspection. From that page, the user can view the otherwise inaccessible-from-within-RD xmldoc content for the selected inspection, navigate to the xmldoc content for the available quickfixes, and submit a pull request to add new examples or fix typos in the documentation. A later PR (?) shall consolidate the web-browser commands ("about" dialog also spawns a process like...
this) so that the "go to some url" wheel doesn't need reinventing every time.
 
6:53 AM
search is semi-fixed now (published whatever changes I had)
and, bedtime
 
[rubberduck-vba/Rubberduck] build for commit b3a9dc59 on unknown branch: AppVeyor build succeeded
 
 
4 hours later…
10:52 AM
We now get Rubberduck.parsing.xml as a build asset. As I understand it, that's necessary for the fancy, cool new auto-doc-builder Mug just released, but what's the value of having that visible to the public on the Releases page, and do I need to download that with my pre-release setup.exe?
 
 
1 hour later…
12:13 PM
I think github puts all built assets on the release page.
 
 
2 hours later…
1:47 PM
Hi all. Back in the days of 16-bit Windows, Symantec/Norton had a utility for un-sticking an app with a locked-up child window. You'd run the utility, pick an app, and it would tell you if it had child windows and give the option to kill them, while trying not to crash the parent app. Are any of you aware of such an app for modern 32b & 64b Windows..?
I just had that happen with Excel/Access open. One of them was jammed and it caused Access to crash and I lost some code. It was acting like there was a stuck child window. It was similar to when you have an Excel cell open for editing, and you get the "bink" sound when switching to the VBA window to edit code.
 
2:22 PM
@spinjector doesn't ring any bells, but sounds useful!
@FreeMan I could probably get the build assets off AppVeyor (they keep old build assets for 6 months IIRC), but it's much, much simpler to grab the build assets off the GitHub release/tag as I need to hit that endpoint anyway to get the download counts. Also much simpler to know which build is for a prerelease tag =)
 
2:42 PM
OK, I was just wondering. Doesn't bother me any, and I can't imagine it hurts anything.
 
it's true that it kind of makes the actual installer asset a bit harder to find, however the "download" links on the home page point directly to the installer executable
 
The RD home page or the GH/Rubberduck home page?
 
the website =)
 
I've always just gone to the Code/releases page
I probably don't spend enough time browsing the RD web site. makes a note...
 
eh, I probably spend too much time browsing it lol
 
2:51 PM
well, then, between us, we make a well adjusted "normal" user!
:D
 
Haha! navigation seems to work everywhere (at last!), except pagination in the search results is still broken
At least search kinda works now
The funny part is that despite I'm so often viewing the site, I just now noticed 2.5.0 is at 8,366 downloads since 12/22
1K/month mark is officially busted
2
 
@MathieuGuindon Regarding the stuck child windows, yes it was. The utility was originally part of Norton Desktop for Windows 3.1, and I've been thinking of taking a stab at creating a modern one in Visual Studio, using the same kinds of API calls as apps like SysInternals Process Explorer... When I have time... (lol)
 
Norton Desktop for Windows 3.1: blows cobwebs off of long disused brain cells...
 
@spinjector Sounds a bit like a Spy++ with teeth
 
Actually yes, I suppose it would be like that...
 
3:05 PM
In other news, last night's publish has replaced the hard-coded "master" with "main" on the website, so we're ready (minus everything that will go wrong) to rename our master branch to line up with the new GitHub default naming. Shouldn't be too complicated on the GH side, since our default branch is "next".
 
master... People woulda had fits back in the early PC hard drive days. If you attached 2 drives to your computer, you had to put jumpers on each to designate one as the 'master' and the other as 'slave'. Can you imagine the uproar if certain people found out about that?
 
@spinjector FWIW, I've had that happen and while I haven't seen any utility, I've found that by doing Show Desktop + Restore on the locked-up app works to get the child window in front. Annoying but it is what it is. I'm fairly sure that Windows 10 broke something in regards to the focus behavior & dialogs but it's too intermittent as I've seen that happen with various applications, not just Office.
 
hm, is ShadowedDeclaration disabled by default? content updater is reading the defaults from https://github.com/rubberduck-vba/Rubberduck/blob/next/Rubberduck.CodeAnalysis/app.config, but I have it at "Error" level in my local config
(and if it really is, ...*should it be* disabled by default?)
 
4:06 PM
[rubberduck-vba/Rubberduck] build for commit 97475d11 on unknown branch: AppVeyor build succeeded
 
4:23 PM
[rubberduck-vba/Rubberduck] retailcoder pushed commit b3a9dc59 to next: added link to inspection details page
[rubberduck-vba/Rubberduck] retailcoder pushed commit 97475d11 to next: extracted IWebNavigator interface
Merge pull request #5548 from retailcoder/weblink

Introduces a link to the website's inspection details page for the selected inspection result, at the bottom of the bottom panel in the inspection results toolwindow.
> I'd like this PR merged for the 2.5.1 release.
> I'd like this PR merged for the 2.5.1 release.
 
I think that's all, everything else isn't as innocuous and can be 2.5.1.x
 
> Putting this into the release will require some additional non-trivial translation work.
 
@Duga ah, crap. Let's skip it then.
 
> @MDoerner ok let's skip it then - the translations are good to go (a few CZ entries need attention, but nothing major)
 
4:40 PM
we do need #5343 though
 
 
1 hour later…
5:57 PM
@this Thanks for the tip about the Windows 10 Show Desktop thing.
 
@this What, exactly does Show Desktop + Restore mean and how do I do that?
 
@FreeMan The scenario is you're doing your thing on an application, and you trigger something that causes it to open a modal dialog. Normally you'd respond to the modal dialog which is right in the front of the application. However, there has been times where that does NOT happen; the modal dialog pops behind the application, which then make it look like it's all locked up.
and you can't click on it because it's expecting you to respond to the dialog but you can't get to it because the application's main window is in the way. The Show Desktop & Restore hack sometimes work to get the modal dialog put in the front of the application it should be.
 
6:13 PM
@spinjector does Process Hacker do what you want? processhacker.sourceforge.io
It's opensource on GitHub so you could easily extend the capabilities if the exact behavior is missing. (Killing a window and not a process)
 
gotcha, so I Show Desktop to minimize all apps (even the one that's not responding), then I click the app on the taskbar and it should show the modal dialog in front of the app, where it should have been in the first place.
I've found that sometimes I can alt-tab to the dialog box, too.
 
 
3 hours later…
9:13 PM
> **Rubberduck version information**
Version 2.5.0.5522
OS: Microsoft Windows NT 10.0.18363.0, x64
Host Product: Microsoft Office 2013 x86
Host Version: 15.0.5233.1000
Host Executable: MSACCESS.EXE

**Description**
A implicite default member access to ACEDAO.DLL;DAO.Field.Value is not recognised, when it should be
SVNID = Nz(rsWork.Fields.Item("ID"), vbNullString)

**To Reproduce**
Add a new module in Access 2013

```
Option Compare Database
Option Explicit

Public Sub test()
 
 
1 hour later…
10:39 PM
> How is the function Nz defined? More specifically, what is the type of its first parameter? Without that information it is hard to say what is going on.
 
10:56 PM
The theme for today is: "When things that seem simple require bizarrely complex solutions"
 

« first day (2244 days earlier)      last day (936 days later) »