« first day (2135 days earlier)      last day (51 days later) » 

12:01 AM
RELOAD!
[Minesweeper] Games Played: 183, Bombs Used: 103, Moves Performed: 21389, New Users: 34
 
 
5 hours later…
5:06 AM
0
Q: How do I get the if else statement to do a decision tree in vba?

Josh BulloughI am hoping to make a quick decision tree using the if statement in excel vba. The point is to have a message with a prompt show up and then it will take the person through the prompts based on the answers. Is this possible to do? Sub Decision_tree() a = MsgBox("Want To Play A Game?", 3) If a ...

 
 
6 hours later…
10:58 AM
@QuackExchange Needs to be closed. Code doesn't work worth a darn.
 
11:28 AM
Darn, I have just written a review.
@FreeMan Works for me.
 
I found a missing End If, and other weird things. Maybe that's just not a good sign for how today's going to go. :(
 
No, there is no missing End If; there is one single-line If statement.
 
ah! that must have been it
back to working on my own code.
 
@FreeMan I hesitate to ask but... did you get the code back?
 
no, not yet.
I just tried connecting to my desktop at the office. TG wanted to update itself, so I said "sure", and it managed to lock things up there.
 
11:43 AM
oof. Sorry.
 
I've asked our IT guy to do a remote reboot for me. Not sure if I can or not. I may do a quick google search
 
when you say lock things up you meanyou can't log into it?
 
I've got 4000+ records in my Dev DB that I pulled from our Azure DB. I KNOW this code exists somewhere. I didn't enter those by hand!!!
TG wanted to close Win Explorer, FF, etc to do its update. I said sure. I then tried to be helpful and closed Win Explorer for it. Now all I've got is a black screen with one Outlook reminder and no task bar
I can connect to the machine, but no task bar or task mgr to see what's going on.
Via RDC, keyboard shortcuts to bring up the task bar are intercepted by the local host, not sent through. to the remote machine.
 
they use different keyboard shortcut
which I never could remember
something like ctrl + alt + end
 
hmmm... didn't know that.
quick ddg search...
 
11:48 AM
yeah, looks like it's ctrl + alt + end: serverfault.com/questions/359976/…
 
winner winner!
 
so if you can get the taskmanager back, you can then restart the explorer.exe
TortoiseGit is a shell extension so it has to restart the explorer.exe, which is why you lost the taskbar and stuff
Probably best not to update while remote....
 
how? I get a menu with Lock, Sign out, Change pwd, Task Mgr
I started TM, but... I don't see a "restart explorer.exe" option.
 
you use the run....
 
you've got to be kidding...
 
11:51 AM
it's on the mgr's menu
 
file | Run New Task | explorer.exe
thats... weird
TYVM!
 
YW!
 
still pretty wonky, though.
I've got a task bar with the Win icon, but none of my pinned task bar items.
 
Such is the joy of remote troubleshooting.
 
oooh... I didn't check "run admin"
 
11:53 AM
huh. Something new.
 
oh... looks like they icons are there, I just can't see 'em
 
I don't remember having to run explorer as an admin just to get pinned task bar items. #TIL
 
Good morning. May I ask a question..?
 
I dunno. the Win Icon was greyed out. I started TM again, launeched explorer.exe w/admin privs and got a file explorer window.
:(
@spinjector you just did.
;)
 
Sorry I always feel impolite butting into the room chat. =-) I'm having something weird; it just started yesterday. Been using RD for years and never seen this... If I record a macro in Excel VBA, RD Code Explorer won't show it, even after a refresh. But I can see it in the old VBA Project Explorer. Is there Is this a known issue..? Am I overlooking a setting..?
 
11:55 AM
jump on in. There's no waiting on protocol 'round here
 
Driving me nuts.
 
wouldn't it be on the account of it not been saved yet?
 
shutdown /r
wish me luck...
 
Any ideas?
 
6 mins ago, by this
wouldn't it be on the account of it not been saved yet?
 
12:03 PM
Oh what? Sorry I don't understand.
OH. No, I saved. But I don't recall that being an issue in the past. It's not working like it used to.
 
not so sure... I copy/pastad that code from the CR post and parsed it. It showed up in the CE without me saving it. It wasn't macro recorder code, but that shouldn't matter..
 
OK - does it appear after you parse 2nd time?
 
HUZZAH I haz codez!!!!
 
Yea that's what I thought. Historically, any recorded code shows up in CE immediately. Also, something I noticed with 2016 is I can now actually see the code as it's recording. I don't recall 2007 ever doing that. But now I can't even see new modules/procedures even showing up in CE.
 
Glad ot hear, Freeman!
@spinjector Sorry, not sure I follow - I asked if the CE eventually shows the new code after 2nd parse?
 
12:07 PM
Now I just gotta remember to quit hitting Ctrl-F2 in RDC... :/
 
what does that do?
@spinjector to clarify, I want to know if the current behavior is showing the code only after 2nd parse or never
 
Ok. Well... the answer to that was "never". But... I just rebooted and it seems ok now. I was trying to avoid that because I had a bunch of windows open, and 2016 doesn't have the Save-Workspace feature any more. It seems ok now. #smh =-/
 
if it happens try, feel free to open an issue with reproduction steps and we can look into what's affecting it
 
Ok, what started it seemed utterly random, so I don't know if I could reproduce it, but I suppose it's possible. Sorry to ask a question that I was able to fix by restarting. =-S
 
hence why many IT support calls end up being a variation of "turn it off, turn it on"
:D
 
12:21 PM
Ok.........wait a minute. Now something related is still happening.
Now CE is showing the wrong procedure names.
For ones that aren't even there any more.
And....so is VBA Project Explorer.
Wow this is totally weird. Just a sec I'll get a screenshot.
Personal.xlsb has Module2 and Module3, but CE and PE show Module1 and Module2..!! There is no Module1, and Module3 is missing..!! o.0
Never seen anything like this before.
On any of my Office VBA machines.
This seems deeper than an RD problem.
brb going to reboot again
 
@this oh, Shift-F2 in VBIDE, it takes you to the definition of the object under the cursor. RDC captures it and does really wonky things with your RDC window. Like Restore down and move 98% off of a visible monitor anywhere.
This is a touch distressing. I just copied 2 .def files from my work machine to the network then to my local repo. I started Access, opened the VBIDE, then told TG to Import code. It says nothing has changed.
it identifies no files on disk as needing to be loaded because they're different than what's already in the VBE
yet they're 2 very different files.
 
I hate Windows 10, but damn does it robot fast.
reboot
Wow it's stuck that way..! Even VBA PE is still showing the wrong module names.
err... Procedure names
Ok this is wild. There was another "Personal.xlsb" code window open in VBA with Module1, but I closed it and now it won't come back.
I think I have some research to do here to find out where things are going. I'm going to temporarily remove all my XLSB files somewhere else and see what happens. Maybe one of them is damaged.
Ok. That seems to have fixed it.
Sorry for thinking out loud into the room. I seem to be ok now.
 
12:46 PM
ummm... @spinjector, the room is called "rubberducking" for a reason...
 
Oh..? What am I missing in the name..? (i can be dense lol)
 
(is OK, I had to be shown the light, too.)
 
oh jeebus. never knew that. and always wondered wth the name RubberDuck came from. our CFO was looking over my shoulder one day and asked me wth a RubberDuck was and I was like ¯_(ツ)_/¯ lol
i guess i have to get one now, but mine is going to be an official archie mcphee devil duckie =-D mcphee.com/products/devil-duckie
 
Ah @ThunderFrame, how we miss thee...
 
ok back to work now... such as it is, social distancing at home with the office manager staring at me... =^.^=
 
1:44 PM
Omg. So embarrassed. I just realized what I did. Not seeing what I was looking directly at. I completely missed the fact that the tree was collapsed and I was confusing 'Module1' with 'Macro1'. #facepalm
Everything was right there in front of my face.
Sorry to waste everyone's time and hog the room uselessly. #shameshameshame
 
59 mins ago, by FreeMan
ummm... @spinjector, the room is called "rubberducking" for a reason...
 
and...you are correct of course. still feel like a fuckwit, lol.
I'll file this under the heading, "Dumb Mistakes To Not Make Again"... =-)
 
2:34 PM
Good news: Got the code recovered!
 
woot woot!
 
Bad news: I'm running into connection string issues again.
I've looked back through my discussions with this, and I'm not seeing where I may have found a resolution.
At this point, at least I've got a work-around - I can run via RDC on my work machine, even though it's not working on the laptop.
My head hurts. It's Friday. I haven't had coffee today. I'm having a hard time caring at this point.
 
3:01 PM
and, even better! Access silently crashes... :(
 
3:18 PM
@FreeMan Are you sure that you have issues with connection string and that the connection isn't simply refused?
If things are set up properly, you should only be able to connect to your databases from the correct network.
 
> ADODB.Command Error Num: 3709 Description: Requested operation requires an OLE DB Session object, which is not supported by the current provider.
 
3:33 PM
Interesting. It seems to be OASIS that's crashing Access when I try to change the "Import from" directory. I've tried clicking in the path box and on the folder icon and both seem to bring it all down.
I could be the extreme slowness I'm having accessing anything on the work network while I'm WFH via VPN, so I'll withhold judgement for now, but this is a smidge irritating...
(copying files at 946 bytes /sec is a bit sluggish)
generally between 1-3 KB/s
 
4:00 PM
carp. Nope, getting the ODC errors on the work machine, too.
On the bright side, doing the OASIS imports via RDC took seconds where it was taking multiple minutes via VPN
 
4:39 PM
@this - there may be a problem with OASIS... I just put a bandaid over the connection string issue. (It's not pretty, but I don't care right now.)
When I went to export code with OASIS, it said that there were 43 code modules to export.
I changed 1 module, and that one module was NOT selected among the 43!
(I've had it export a ton of modules because I accidentally changed the case of a variable, so I wasn't shocked.)
I initially did the big export of 43 modules assuming I'd changed a variable case and I wanted to see where it was. I went to my Source directory and it had a green TG check mark, and diff reported zero differences.
That's when I went back to the export and it flagged those same 43 w/o flagging the one changed module.
After forcing that one to export, I get the red exclamation and it shows up in the diff
 
5:02 PM
Wow, @FreeMan. I feel your pain with the slow link. I'm on DSL over here but even my VPN to work is not this bad. Are you waaay out in the boonies? Are you on a satcom link or something?
My corporate network is fast so I'm seeing close to line speed on my connection. I have 80 down and I'm getting 76 down from the VPN.
 
DSL gets you 80 down? didn't realize it could go that high
 
VDSL, it's a bonded pair of 40mbit links
 
aha
 
Nope, I get around 100/6 via Comcrap. (Yes, that asymmetric.) I think that our corp VPN servers are being blown out of the water by having at least 10x more people using it than they scaled for.
 
Yeah, 6 up is trash but you should still have fast pull of a query from the network. Sounds like the problem is definitely on their end
 
5:06 PM
but, depending where on the network I have to move things, I'm getting Win reporting speeds in the bytes per second range.
my 6 up is more than fast enough for my kids to stream TV/movies via Emby. Granted, they get transcoded to be more compact, but nobody's complained about quality.
 
Wow, I mean slow Ethernet was 10mbit back in the day. I can't imagine comcrap acting like anything less is acceptable. Usually a 100meg link has 25 up.
I'm supposed to get fiber next month. I'm not sure what they will offer me but I'm taking top tier. I'm hoping for a full symmetric gig link
 
our local telco has fiber to the house. They require a landline phone (and charge, of course) so it wasn't worth it when they installed. I'm considering looking at their rates again. If I can get equivalent speeds for equivalent price without massive install cost (the fiber's been run out front, but hasn't been brought into our house yet), I may make the switch
 
DO IT! The cheap fiber is usually a symmetric 250 for less than you are paying now
Try to get a deal on the install. Say you need it for WFH, crisis, low cash. Give me a deal plz
 
lol... good thought.
Monday...
 
5:41 PM
@this - next time you're by...
A couple weeks back, you'd helped me with this logic.
I get a recordset from our Azure Data Warehouse, then insert it into an Access local table, then retrieve it from the local table, then finally insert it into our local(ly hosted) SQL Server.
I got to thinking... why the heck am I inserting it into the Access table in the middle?
When I get the data from the local table, I join it to a couple of server-hosted tables in order to look up some values that are necessary and pass those along in the recordset to the method that inserts into the server, but there's no reason I couldn't do the join in the INSERT statement, is there?
The insert/retrieve from the Access table seems to be the slowest part of the process. Even if it weren't, removing that would definitely speed things up.
 
@M.Doerner "The you new it up and same it in a variable Dim userInteraction As YesNoUserInteraction ..." did you intend to use 'save' instead?
 
Yes, feel free to edit.
 
 
3 hours later…
8:20 PM
I have a question on the Assignment is not used inspection.
` With DummyDataWS
Dim sourcePlayerIDTeamARange As Range
Set sourcePlayerIDTeamARange = .Range(.Cells(3, 1), .Cells(50, 1))
End With
With ScoringInputWS
.Range(.Cells(17, 3), .Cells(64, 3)).value = sourcePlayerIDTeamARange.value
End With`
Seems I am using the assignment by using the value property.
I know I didn't use the markup right...
 
This is a known bug. When @Hosch implemented it, he thought that variables are scoped to blocks in VBA, which is not true.
I have to admit that I do not really understand how the code path analysis he built works.
Basically, that inspection is very broken atm.
 
ok, thanks...
 
 
1 hour later…
9:44 PM
If I have Inspections grouped by inspection and select all in the FunctionReturnValueAlwaysDiscardedInspection then apply Convert to Procedure it only fixes one, not all. Is that the only way it works?
 
9:56 PM
 

« first day (2135 days earlier)      last day (51 days later) »