The Official Status Thread
-
@Magus I'm not looking for it on mobile. But @Tsaukpaetra said he was fixing a singleton like that not long ago.
Are you sure he didn't made that PR?
-
@accalia said in The Official Status Thread:
it took me about five months to notice the @accalia in your avatar.....
I've ALWAYS noticed the @accalia in your avatar.
-
@Lorne-Kates said in The Official Status Thread:
@accalia said in The Official Status Thread:
it took me about five months to notice the @accalia in your avatar.....
I've ALWAYS noticed the @accalia in your avatar.
-
@Jarry Quite; he'd have recognized me by now. Besides, I don't imagine he'd implement a singleton that way, especially if he was fixing one.
-
@Lorne-Kates said in The Official Status Thread:
@accalia said in The Official Status Thread:
it took me about five months to notice the @accalia in your avatar.....
I've ALWAYS noticed the @accalia in your avatar.
i'm flattered!
-
@Luhmann said in The Official Status Thread:
action correctly.
Yeah, a tonne of things in Excel don't work properly unless the thing you're actioning is properly activated/in view.
This was so bad that I turned off screen updating for quite a few things to stop the rapid flickering that necessarily occurred from it.
-
@Luhmann said in The Official Status Thread:
@HardwareGeek
So @Tsaukpaetra fancies ginormous ears or ...Yeah let's just keep it at that
I said I thought it was a bad idea, why would you take that to mean I "fancied" it?
-
@Magus said in The Official Status Thread:
@Jarry Quite; he'd have recognized me by now. Besides, I don't imagine he'd implement a singleton that way, especially if he was fixing one.
I agree with this statement.
-
@Tsaukpaetra said in The Official Status Thread:
This was so bad that I turned off screen updating for quite a few things to stop the rapid flickering that necessarily occurred from it.
Oh, you should always do that in your script before you do anything that changes stuff. (It's also like 10x slower to do anything without screen updating turned off, so there's another good reason aside from the flickering.) But from an external VBscript, if the script crashes after that, it leaves Excel frozen in that state where it doesn't respond to user interaction at all. You have to hack the script so that all it does is turn screen updating on and run it again to get Excel back into a usable state.
-
@anotherusername said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
This was so bad that I turned off screen updating for quite a few things to stop the rapid flickering that necessarily occurred from it.
Oh, you should definitely do that from the very beginning before you do anything that changes stuff. But from a VBscript, if your script crashes after that, it leaves Excel frozen in that state where it doesn't respond to user interaction at all. You have to hack the script so that all it does is turn screen updating on and run it again to get Excel back into a usable state.
Oh, that's part of the
ON ERROR GOTO ResetScreen
section.Also, if forgotten, you can do that from the Immediate window without hacking, but literally nobody knows you can do that...
-
@Tsaukpaetra said in The Official Status Thread:
Oh, that's part of the
ON ERROR GOTO ResetScreen
section.You're thinking of VBA; it's slightly different.
VBscript doesn't have
On Error Goto label
.No, really. It doesn't.
VBscript has two types of error handling:
On Error Resume Next
, andOn Error Goto 0
. You can do some error handling inResume Next
mode, but you have to explicitly check theErr
object after every operation that can possibly cause an error to see if an error was generated.Also, if forgotten, you can do that from the Immediate window without hacking, but literally nobody knows you can do that...
Pretty sure you can't get that to open if you've turned off screen updating from an external VBscript, though.
-
@Tsaukpaetra said in The Official Status Thread:
Immediate window
I wonder how many even know that's a thingy.
@anotherusername said in The Official Status Thread:
VBscript doesn't have
On Error Goto label
.I knew it was shit, but seriously? That's pants-on-head retarted.
-
@Tsaukpaetra here, try this. Open a brand-new Excel window with the default workbook title of
Book1
(if it's localized to something else, change that in the code below). Then run this VBscript (not from inside Excel; paste it into Notepad++ and save it as a separate.vbs
file --test.vbs
or something -- then launch that file to execute it). It'll die with an error message, and leave Excel with screen updating disabled. See if you can get to the Immediate window to change it back... (you can comment out theErr.Raise 507
line that crashes the script and run it again though)On Error Resume Next Set WorkBook = GetObject("Book1") Set XL = WorkBook.Application On Error GoTo 0 If TypeName(WorkBook) = "Empty" Then Err.Raise 432, "Book1 not found. Open a new workbook and try again." End If XL.ScreenUpdating = False Err.Raise 507 XL.ScreenUpdating = True
I was able to close Excel after running that, but nothing inside the window would respond -- including the "View Code" option that would've actually brought up the VBA editor with the Immediate window. Only if I had already opened the VBA editor, then yeah, I was able to run
Excel.Application.ScreenUpdating = True
in the Immediate pane to bring things back to normal again.
-
@accalia said in The Official Status Thread:
i'm flattered!
OMFG WHO DROPPED A PIANO ON YOU!??!?!?!/
...
oh wait that's actually spelled right nevermind.
-
@Lorne-Kates I blame Jeremy Clarkson.
https://www.youtube.com/watch?v=wSXyIss8bIQ
-
Status
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH! IT BUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUURNS!
-
@HardwareGeek said in The Official Status Thread:
Only Democratic Presidents are legitimate, I guess.
The garage is .
-
@accalia Are you OK there?
-
Status: Vaguely wondering if I could build some kind of interesting simulation in service fabric. Maybe something rather like Dorf Ortress. It just seems like possibly a good platform for such a thing...
-
@accalia said in The Official Status Thread:
Status
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH! IT BUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUURNS!
:this-is-fine.png:
-
@accalia said in The Official Status Thread:
Status
If only there was some way to combine date and time information. If only …
-
@abarker Some sort of timedate? Unpossible.
-
Status
-
@abarker said in The Official Status Thread:
@accalia said in The Official Status Thread:
Status
If only there was some way to combine date and time information. If only …
THEY ARE
datetime
FIELDS!BOTH OF THEM!
:majorly_freaking_out_here:
-
-
@loopback0 said in The Official Status Thread:
@accalia said in The Official Status Thread:
THEY ARE datetime FIELDS!
You gone done
MY FREAKOUT CARES NOT FOR NEARLY CRASHING PLANES! CALL ME BACK WHEN ONE ACTUALLY CRASHES!
-
@abarker said in The Official Status Thread:
@accalia said in The Official Status Thread:
Status
If only there was some way to combine date and time information. If only …
BUT THEN HOW DO YOU
SELECT * FROM tblTABLE1 WHERE (((dtDATE1 = dtStart) AND (dtTIME1 >= #7:00:00 AM#)) OR ((dtDATE1 = dtEnd) AND (dtTIME1 < #7:00:00 AM#)))
Because obviously you can't just do this:
SELECT * FROM tblTABLE1 WHERE dtDATE >= dtStart + #7:00:00 AM# AND dtDATE < dtStart + 1 + #7:00:00 AM#
Adding dates? Come on! Computers aren't magic, you can't do that...
-
@Jarry said in The Official Status Thread:
But @Tsaukpaetra said he was fixing a singleton
-
@accalia said in The Official Status Thread:
MY FREAKOUT CARES NOT FOR NEARLY CRASHING PLANES! CALL ME BACK WHEN ONE ACTUALLY CRASHES!
(from a couple of years ago…)
-
Status: Hmm… I left a post that could have been flagged for , and no-one's noticed…
I expected better of you, WTDWTF!
-
-
@RaceProUK said in The Official Status Thread:
I expected better of you, WTDWTF!
Spotted the right there.
-
@RaceProUK said in The Official Status Thread:
Hmm… I left a post that could have been flagged for , and no-one's noticed…
Well there are so many, it's easy to miss one
-
@RaceProUK said in The Official Status Thread:
Hmm… I left a post that could have been flagged for , and no-one's noticed…
This sounds suspiciously like work …
-
Status: Obfuscated snapshot from one of my personal spreadsheets:
Bank Bonus Date Opened A $300 Last Summer B $300 Last Summer C $400 Last Month D $300 This Month E $300 This Month F $250 This Month G $100 This Month I may need help.
-
@Polygeekery said in The Official Status Thread:
Of course, one night I came in and it was cold outside and I had a hoodie over my face and they both flipped out and nearly attacked me.
I've had that happen. It's really funny their reaction when they realize it's me "OMG IAMSOSORRYIAMSOSORRYIAMSOSORRY"
-
@dcon said in The Official Status Thread:
I've had that happen. It's really funny their reaction when they realize it's me "OMG IAMSOSORRYIAMSOSORRYIAMSOSORRY"
As a kid I had a Black Lab that always slept on my bed. One night he was dreaming, making little barking noises and such, kicking, etc. Then he started growling in his sleep. Finally he woke up and kind of lurched at me, thinking I was whatever was in his doggy nightmare. He only made it a couple of inches before he stopped, laid his ears down and looked really sad and sort of ashamed of his behavior.
He was a great dog, with a very apt name: "Buddy".
-
@Polygeekery said in The Official Status Thread:
He was a great dog, with a very apt name: "Buddy".
-
@RaceProUK said in The Official Status Thread:
Status: Hmm… I left a post that could have been flagged for , and no-one's noticed…
I expected better of you, WTDWTF!
We stopped doing badges or we would have already tried to goad you in to rage quitting with whoosh badges.
Not because we don't like you. We do. It is just that we are a group that finds such things amusing.
-
@Polygeekery said in The Official Status Thread:
Not because we don't like you. We do.
Falgged for Liable!
-
Status: I'm happy that Twitch videos offer both 720p30 and 720p60 options for playback :D
-
@Tsaukpaetra said in The Official Status Thread:
@Polygeekery said in The Official Status Thread:
Not because we don't like you. We do.
Falgged for Liable!
Go home @Tsaukpaetra, you're
@lucasdrunk.
-
@Polygeekery said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@Polygeekery said in The Official Status Thread:
Not because we don't like you. We do.
Falgged for Liable!
Go home @Tsaukpaetra, you're
@lucasdrunk.Acknowledged. Traveling will commence in five minutes.
-
@japonicus said in The Official Status Thread:
Status: ...and they wondered why they were getting filename collisions.
$filename = sha1(mt_rand(0, 1000000)) . '.jpg';
(we generate 10 000s of these 'unique' names)
sha1 obviously adds entropy because there are more bits!
-
Status: apparently it's the season for getting knocked up. Wondering if they make cards like this:
...but with a more bitter, "it's so great that you have a relationship like that" tone.
-
@anotherusername Imma ask my dad, he works for a greeting cards company.
-
@Tsaukpaetra said in The Official Status Thread:
@anotherusername Imma ask my dad, he works for a greeting cards company.
-
@Tsaukpaetra said in The Official Status Thread:
turned off screen updating
Oh yeah that's a required line in all vba stuff
-
@Tsaukpaetra
But how can you now if you haven't tried it?
-
@Luhmann said in The Official Status Thread:
@Tsaukpaetra
But how can you now if you haven't tried it?... :/ You lost me. What does thinking have anything to do with trying?