« first day (2090 days earlier)      last day (1090 days later) » 
00:00 - 20:0020:00 - 00:00

8:03 PM
> an alternative workaround that might be quicker would be using `Windows + [Arrow Keys]` with the window having focus to make it show up as desktop-splitting and bringing the window top onto the screen.

You could also try adjusting your display settings such that the top edge of monitor 2 aligns with the top edge of monitor 1. I assume that Windows internally renders to a bounding box around the combined resolution of both monitors, resulting in the window being "pushed out the top" of monit
 
@Vogel612 Win + arrow keys does not work on the toolwindows.
 
huh... why, though?
 
@Duga that is an interesting one
 
I don't know, but it only works for the VBE, not the child toolwindows.
I guess that has something to do with the MDI nature of the toolwindows.
The method with Alt + Space, M works, though.
I have checked it with a live code inspections window.
@Duga Oh no! I guess that is my fault.
I will write a hotfix immediately.
 
8:20 PM
@M.Doerner In reference to the #5402 or #5401?
 
Oh ok. So we're missing a reference? How would it have built?
I was thinking he had a bad file or some serious security lockdown.
 
No, that looks like a missing binding in the IoC installer.
 
@Duga uhm, starts fine here
Version 2.5.0.5359
OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64
Host Product: Microsoft Office x64
Host Version: 16.0.12430.20264
Host Executable: EXCEL.EXE
 
8:24 PM
I want to say that we don't normally distribute Microsoft.CSharp.... right?
 
yea no we don't.
 
it's something that comes with the .NET FX, so if it's not working, it's the machine that's hosed, right?
 
@MathieuGuindon which toolwindows do you have set to "open on start"?
 
I'll check whether it works here.
 
I was about to suggest to test on another machine. I don't know if they can have a security policy that prevents using the Microsoft.CSharp.
 
8:26 PM
> Do you have another machine to open it on? Judging from the logs, it looks like there's an issue preventing you from loading the Microsoft.CSharp assembly; whether due to a security policy or actually missing the required file.
 
Meh, went ahead and commented.
 
@Vogel612 none
 
Hm, no problem here.
 
hmm ... interesting...
 
then that surely means it's the machine that's hosed.
 
8:27 PM
I'm going to rebuild the merge commit on AV to re-create the pre-release
 
(or locked down so severely to hose it)
 
gotta go get the kids, bbiab
 
hmm. we are not using 4.7.1, though.
 
8:30 PM
but honestly, three working installations seem to confirm that the issue is isolated to the host of that user
 
@M.Doerner TYVM for another hotkey.
 
But it's odd that there's a similar issue with loading the core assembly as the one w/ WPF that they bungled up.
AIUI, they are changing internally how to resolve the references for the core assemblies, and we're getting cut for it.
 
> At a glance it looked like a severe oversight on our part and I went and swiftly deleted the pre-release, but then that specific build runs fine here and on other machines... could something be broken on your particular machine's .NET setup?
 
is `foo` or `bar` considered the factory, in the below?  trying to go through some starting material on getting more versed in OOP and am getting a little lost

sub foo()
    with new bar(true)
        'do something
    end with
end sub

sub bar(val as boolean) as object
    if val then
        set objBar = createobject("firstObjBar")
    else
        set objBar = createobject("secondObjBar")
    end if
end sub
i think foo is a constructor while bar is the factory?
"a factory can be a subroutine that returns an object" seems to fit the above, as bar is object
 
VBA?
there's no constructor
the constructor would be what's invoked in bar when you do new bar
(don't mistake it for the Class_Initialize handler)
bottom snippet, sub bar(..) as object would be function bar(..) as object ;-)
if set objBar = ... means to return the object, then yeah that makes it a factory method
factory method: a method responsible for creating an object
factory: an object responsible for creating other objects
^ say, strictly speaking
 
> @bclothier I don't have another machine I can work on for it, but @retailcoder I'll definitely look into the .Net setup. My company HAS made some changes in the past few months.
 
@MathieuGuindon i think that's exactly what i was doing
i was only getting to literals in trying to understand, since this feels very dry and it's my first time really digging into the concepts (i spent a lot of time working on "classes" and am just now getting to this topic)
 
I could be wrong, but I think _Initialize and _Terminate are just callbacks like any other "base class" events - invoked from the actual logic that constructs/destroys the object instance
 
9:37 PM
copy; i think i'm following
 
Keep in mind they're funny, though.
Particularly the Initialize
Generally speaking it is not safe to call code outside the class module when you are inside the Initialize code
 
my rule of thumb would be that any code that isn't just plain straightforward initialization of internal state, doesn't belong there
i.e. Set this.Things = New Collection & the like
 
Yeah, that's a good rule.
 
copy
 
last thing you want is to hit a database and populate a bunch of comboboxes in there
 
9:41 PM
Gosh, I need to get that article about class module out.
 
I was wondering when that draft would show up :)
 
@MathieuGuindon #ThisIsFine
yes, I finished it, I think.
The thing is that I have no idea how to get it to convert to WP nicely
I may just post it as a PDF so that the internal links works.
 
I'll convert it if you want
 
(not to mention the stupid insistence on calling it a " chapter")
I've not figured out how to coax Word to let me change that word.
Sure, I think you have the latest draft.
 
writes a Word VBA TypeScript add-in to convert Word docx to WP
 
9:43 PM
LOL
I did seriously contemplate that, TBH.
I was sorely disappointed when I found out that Word's "Save As HTML" is still crapatastic as it has been.
I'm not attached to the particular formatting; I only want to keep the internal links intact (I guess in HTML, that'd be now anchors)
 
I'll send you a gist - I'd like you to put up the WP draft, so it's credited to you
 
That works
if it doesn't pan out, no sweat; PDF is always a good format
 
my version still had the last part about UI, are you sure that's the latest one?
 
going to send you another
sent
The UI part has been split into a new paper, so I can deal with the design patterns at a very high level.
 
hm, "but in the end" (first paragraph under the two numbered statements) looks like a link but isn't one
 
10:00 PM
no that's Word's grammar checker
 
it wants me to add a comma
which doesn't make sense. At least I don't think so.
 
, but
it's not wrong, "but" always comes after a comma and never begins a sentence... in theory ;-)
 
Yes but there's another comma at the the end, ...
In my peabrain, 2 commas makes the clause an independent clause (? not sure if that's right name) which implies it's just a mention in passing.
 
arguably a comma could also fit after the "but"
but, in the end,
 
10:03 PM
Better solution: ...the principles. In the end, it
 
Word does not think too highly of me splicing together run-on sentences. :-D
 
@MathieuGuindon But what if it's an appropriate to start a sentence with it?
 
There's no need for a comma in that case.
The issue only comes up when you try to splice two clauses sentences with a "but".
 
10:06 PM
I just make sounds and hope they're intelligible by other people. #Words always win against me.
 
in theory there's always a better word than "but" to start a sentence with
 
Generally, you could express two opposites ideas in a sentence but sometimes, it feels awkward when you try to do so in one sentence.
 
@this use endash instead if you want to make it painfully clear that it's just an interjection
 
^^ a good example of "but" abused.
Maybe "more often than not" rather than "sometimes", though.
@Vogel612 that implies that the reader is aware of the same convention. I don't have control over the conventions that the reader expects me to follow. A number of people read 2 commas as an interjection.
 
> While generally you could express two opposite ideas in a single sentence, more often that not it feels awkward.
 
10:09 PM
This shows how woefully behind 'Murica is in education. The German is instructing the Americans on proper English grammar and usage.
 
@this two commata isn't necessarily an interjection, it could just as well be a second order subclause
 
@Vogel612 Yep, much better.
@IvenBach I blame English.
@Vogel612 True, but that's also the reason I try and avoid sentences with 2 or more commas unless it's actually a list of something.
 
@IvenBach I wouldn't be surprised to be corrected by an American language learner on my German grammar
 
@ticker "Why is this happening" just won Title of the Year
 
@this Yea, English generally prefers shorter sentences.
 
10:11 PM
first sentence: > not sure why i am getting the above error
 
@Vogel612 touche. I did the same with Spanish while living in Costa Rica.
 
above what?
 
so wierd....
 
@IvenBach FWIW I would put that particular quirk of mine onto my Latin teacher
 
i open a query def into a record set
and movefirst tells me Operation is not supported for this type of object.
 
10:13 PM
yea, movefirst is optional
 
that'd be the case if you had a forwardonly recordset. Also, ^
Many samples show doing a MoveFirst right after opening a recordset which is really wrong.
 
Set rs = qry.OpenRecordset(dbOpenDynaset, dbSeeChanges)
 
After the opening, check the rs.Type - is it still dbOpenDynaset ?
and are you checking for BOF/EOF?
 
yes
to both
 
is the querydef a local querydef? Based on a linked table or something?
 
10:16 PM
the exact line has If Not (rs.EOF And rs.BOF) Then right before it
yes
its a parameterized query
i feed it a primary key, it outputs a specific record
this particular code has been in production use for around 2 years
and this is hte first time its berfed
under locals, i can see the data in the recordset
 
open the query in design view, make a minor change, then save & close it, open and undo the change, then save it again. Does it work again?
 
damnit. i forgot to relink the table after removing a useless collumn
-_____-
 
stale linked table would be a reason why, I guess.
 
yep
that was the doodle
-___-
 
Life's a bowl of cherries.
 
10:23 PM
sometimes you bite on hard things?
 
@this "To provide it with a name, we can save the class which will prompt VBIDE to ask you to provide it a name." -- I'm guessing that's Access-specific?
 
not necessarily?
don't you have get prompted with a dialog to provide a newly created module with a name?
 
What?
 
it just gets some default name, and then you rename it in properties
 
10:29 PM
oh wow
In Access, if I add a new module then ctrl +S in VBIDE:
 
guessing IStorageStream implementation-specific
 
as you see, it has the default name but I have to "save as". Yeah
Most likely, since it came from VBIDE.
that's why I thought it was just a VBIDE thing
with Excel, though, if you have a new blank workbook, and try to ctrl +S in VBIDE, you get prompted to save the whole workbook.
 
Ctrl+S in Excel's VBE just saves the host document
...which has the side-effect of saving the VBA project :)
 
same for Access, except for the renaming thing
and do you see this in Excel?
 
I wish
(nope)
 
10:35 PM
Ok, GTK.
that also means that any instructions around save will be host-specific even when working in VBIDE exclusively. :\
 
That said, manipulating the name via the Properties TW does work the same way so I might just revise that part
 
although, AFAIK only Access is being special here
 
hey it's red....
 
does it miss its purple?
 
10:39 PM
some old timers once told me that in Office 97, the modules were saved separately but that changed in 2000. VBIDE was made with "module is a file" originally and used to have a separate command for compiling all the modules.
TBH, I think purple more of a 2000/2002/2003 when gradients was a big thing at Microsoft. In 97 & before it was a yellow key
Hmm, maybe not.
I don't remember that. But then again, I was too busy picking my nose at that time soooo....
 
probably was what i was thinking of:
 
oh wow
dat serif font
 
IKR?
 
dat kerning
 
10:42 PM
MSFT was.... unhip.
 
then came Clippy
 
Remember that they also didn't want to pay to use Helvetica.
 
@this I love how that's the whole screen and it's like 640x480
or is it 800x600?
no, 640x480
 
back then, if you tried to show it on a 800x600 monitor, it'd be fugly
resolutions wasn't exactly a high priority for lot of programs back then.
 
I want to go back in time and tell 1997 me that in 20 years 1920x1080 is pretty standard stuff
 
10:45 PM
heck, even clock timing wasn't a thing to worry about back then.
remember the turbo button?
 
who doesn't!
 
the millenials!
 
That's some throwback images.
 
 
10:47 PM
@MathieuGuindon How about future-Mug would be and Excel MVP? That'd be more unbelievable.
 
#ThanksMicrosoft
 
bleh
bound forms are annoying
i have a sub form that for some reason wont display any data
the query behind works when ran
just doesnt pull data up on the form
-___-
i think im just having one of those days
 
it's a stupid little thing. it's always a stupid little thing.
 
^
 
im doing the lame forms!formname!txtfield method on hte query
its pulling data
it just... isnt showing it
 
10:50 PM
is the subform linked?
 
no
the main form isnt bound
 
Ok, but you still can link it even on aunbound main form
 
really.
well crap.
 
yes. just use a control on main form (could be hidden if you don't need it displayed)
 
interesting
 
10:52 PM
then reference it in the master field; the child field has to reference the actual field on the recordsource, though.
 
i clicked ... and it says my subform is unbound?!
but it isnt?
 
O_O
i deletedthe subform
and it crashed to desktop
no error
then when it tried to re-open
it failed
wierd
the subform when opened on an unfiltered query wont show data
O_O
even when i directly link the table it borks
now the original subform exploded
wtf
 
Anybody in the pond do ham radio?
 
@KySoto wah... my sympathies.... :-/
 
11:01 PM
yeah, i dont know what the heck
 
@SmileyFtW "ham" radio? what if I prefer bacon?
 
looks like its about time to roll back
 
^^ :wah-wah-sound:
 
@MathieuGuindon - bacon is ham?
LOL
 
oh, Muricah.
 
11:02 PM
<G>
 
pretty sure ham and bacon comes from different parts.
 
it's a worldwide thing.... methinks.. LOL
 
Bacon from the belly, and ham from the rump, I think.
 
yum... pork
@this - struggling...
 
11:04 PM
thus, the porky pig says "th-th-th-that's all folks!"
 
editing
 
hm, food o'clock
 
cocktails first
 
don't you mean pig o'clock?
 
well that went off the rails quickly... <G>
 
11:06 PM
Homer: What about bacon?
Lisa: No.
Homer: Ham?
Lisa: No.
Homer: <expasperated>Pork chops?!</expasperated>
Lisa: <irritated>Dad... Those all come from the same animal.</irritated>
Homer: :laughs: Yeah right Lisa. A *wonderful magical animal*.
 
oh, was expecting <spider-pig.gif>
 
Independent thought alarm. I miss these good episodes.
Back to work.
 
night all..
 
'night!
@this you're going to think I'm a grammer (argh gosh typing this hurt more than I want to admit) nazi or something, but I believe "we've hid" should be either "we hid" or "we've hidden"
also: learnt (en-EN) vs learned (en-US)
oh, I'm an idiot
I can set the author on a draft
 
11:50 PM
@this the draft is up on WP if you want to review it
(needs a title)
Should there be a code file or two in the rubberduck-vba/Examples repository for it?
 
00:00 - 20:0020:00 - 00:00

« first day (2090 days earlier)      last day (1090 days later) »